Can somebody help me ?
Hi friends. I need your knowledge, I am starting with AppSheet. The proceeding know how to do it in Excel but I donโt know how to do it in AppSheet. I have two columns.
Column 1 (start dates)
Column 2 (end dates)
From the initial dates I would like to know
1- percentage of time elapsed between start and end date
2- status of the activity.
If today () is equal to the start date. โActivity startsโ.
If Today () equal to end date โActivity delayedโ
If today () is between the end date and the initial tab " activity in execution "
I have tried to make these formulas similar to how it is done in google sheets but I canโt do it.
Welcome to the community !
Here are some documentation that my help you:
about percentage, you will need to make a calculation based on total hours
User | Count |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |