I am trying to send notifications based on multiple cell data but the default is set to "or when". I need both variables to be met before sending the notifications. I would hope this is easy and I am just not seeing it.
I'm curious what others say on this one. I thought it would be an easy one but I think you have to create and IF statement then create the alert based on the results of that formula.
Hi,
Depending on your specific use cast this can probably be set up with the help of helper columns. For example. When criteria 1 and 2 are correct a checkbox is checked, and that will trigger the rule.
Would that work?
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I am trying to create a Form that requires the user to supply information related to any item existing in the Primary Column. If I pull that existing field into my form, the user entry is a free-form field and I can't figure out how to restrict it (other than validating by data types). If I add a new field with a dropdown…
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
