Hey everyone,
I’m trying to use Appsheet Project Management to also track effort in hours. I was hoping that there could be a column called Time Spent in which a user would add their hours spent on a project for that day/week (depending on when they want to update) and that number would add to a rolling count of Total Effort for the project. The Time Spent column would then clear. Example: Total Effort displays as 12, user edits project and goes to Time Spent column and adds 8. Total effort will now display as 20 and when they go to edit Time Spent is now blank or at 0. I did try doing this as an appscript in my google sheet data source but it doesn’t seem to work when the values are being entered from Appsheet.
Thoughts, ideas? TIA