Sign in to join the conversation:
Do Smartsheet forms support question branching to reduce the number of question an end user sees?
Thanks
Becky Menning
BJC Medical Group
Hi @Rebecca Menning You can build logic into forms by selecting the Logic option when you select a field (you can find this on the right hand side of the form settings)
Let me know if you need help or just a second pair of eyes :-)
I am having a problem with a formula. Does the COUNTIFS have a limit on the number of "logical expressions" used in a formula? My formula below: =COUNTIFS({Opportunity and task orders}, <>"", {2025 Opportunity Status}, OR(@cell = "8.0 - Lost", @cell = "9.0 - Client Not Selected", @cell = "5.0 Awarded Contract Vehicle",…
Formula that I am using is the following: INDEX({Range 1}), MATCH({Search value}, {Range 2}, 0)). In this formula Range 1 and Range 2 referencing another sheet and Search value referencing the value in the current sheet. The value in the current sheet is also based on formula and when using INDEX, MATCH with search value…
Hello all, I am looking for some help with a formula. I'm super close to getting it but can't figure out the last piece. Goal: I have a sheet tracking task completion and want to calculate, month by month, the percentage of tasks completed for each person. Setup: Level 1 rows = person’s name (owner of tasks) Level 2 rows =…
