Forum Discussion
IFS Formula and time
- Jul 01, 2020
I'd recommend creating a table for the amounts to be added....as I've done in the attached. The first column also serves as the basis for the drop down list in selecting the city.
The formula is mostly a matter of entering the numbers in "time" format.
I'd recommend creating a table for the amounts to be added....as I've done in the attached. The first column also serves as the basis for the drop down list in selecting the city.
The formula is mostly a matter of entering the numbers in "time" format.
Ive attached some screenshots
- stephanieporterJul 01, 2020Copper Contributor
mathetes FIXED IT!
- mathetesJul 01, 2020Silver Contributor
That's great. It's always better to have fixed it yourself. Makes for a much better learning experience.
Nevertheless, don't hesitate to come back with questions when you get stumped.
- stephanieporterJul 02, 2020Copper Contributor
Thanks so much! Do you have any idea how to make column A a time only picker? I already have a column which is a date picker. I want a second date picker for column a but I want it to be time only. I'm not sure how to code for 2 different time pickers in the same project. Doesn't seem to work. mathetes