Automatic population based on answers
I am new to Smart Sheet and are having a problem trying to set up an automatic population. I have a cell with multi dropdown, based on what a person selects the answers for two other cells on the same rows are predetermined.
If a meeting is X date then the date to confirm attendance is Y and agenda items are due Z date sort of thing. There are 7 meetings each with their own attendance and agenda items due dates. I will be setting reminders for each dates. I have tried the IF formula but cannot get it to do more than one situation. I have tried a workflow but as soon as I run a second workflow is over writes the pervious results.
Any and all suggestions greatly welcome 😀
Help Article Resources
Check out the Formula Handbook template!