i mean, i could use a formula to calculate percentage based on total vs actual number (e.g. hours logged in the system), but I don't quite understand how do I then show the resulting number as completion percent, or perhaps even as gauge graphic
s
silly-pharmacist-44942
05/30/2023, 8:05 PM
Hi Juraj, you may need to use an automation (either on Airtable if you are using it or on Zapier) to fill a new cell with the result from another cell. It wouldn’t be possible to use the percentage field icons with a formula field.
h
helpful-caravan-75149
05/30/2023, 8:11 PM
@silly-pharmacist-44942 can zapier update a stacker field? the trouble is, i'm using salesforce as a backend and need to use stacker fields to display these numbers, as there's no way(?) to tell stacker to display a number field (imported from sfdc) as, say, a bar.
helpful-caravan-75149
05/30/2023, 8:30 PM
aaah, nevermind, it actually does exactly that, but i've been either blind or overworked 🙂 thanks, anyway!