Hello all, I am using SS to process work orders. People fill out a form which has a priority dropdown column with classifications such as urgent, semi urgent, can wait etc... I wanted to see if i could write a formula in the deadline column to calculate a date based on the priority picked. ie- if someone picks urgent, the…
我使用移动应用那一种形式t has approx. 100 fields that takes someone an hour to fill out sometimes with 5-10 minute pauses in between filling fields. It is for a multiple building property inspection so they have to drive a golf cart between buildings to check the different things that are asked in the form…