When using reports, the fields are not calculating simple math equations. Any ideas.
Hi,
Unfortunately, it's not possible at the moment to do calculations or use formulas in reports, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
All formulas and calculations have to happen on the sheets.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I created a "move row to another sheet" automation where the trigger is when rows are changed and ACTIVE / INACTIVE status changes to INACTIVE. When I changed the status in one row, the automation was triggered and now all of my rows are gone, and they are not on the destination sheet either. Where is my data? There is no…
I have a sheet for which I've provided a publish link to many unlicensed users. They use the sheet to attach files to rows. This has been working as expected for multiple years previously, but today, we've discovered it will not allow them to attach files to rows and they're met with the message "This action has been…
I have a number of reports which live in a workspace. This workspace has a handful of admins, and about 40 licensed users who have editor access in the workspace. Is it possible for these editors to sort reports? Or do I have to make all of them workspace admins for that functionality to be a thing? Seems a bit much…