Sign in to join the conversation:
I want to raise the flag when I have a number in a cell that is >=0 but <4. how do I write a formula that will raise the flag and not include the blanks
I think you want something like this:
=IF(ISBLANK([Column Name]@row), 0, IF(AND([Column Name]@row >= 0, [Column Name]@row < 4), 1, 0))
Make sure the column you put it in is a Flag type, and change Column Name to the column you are analyzing.
Thank you, that was a big help.
You are very appreciated
Greetings- I have a drop-down column where a staff member is emailed (request an update) if a row is marked as "assigned". If row 1,2,3 are assigned to the same staff member within a few mins, that staff member receives 1 email rather than 3 separate emails. We want each row to be a separate email so they can mark that row…
All of the automation workflows on all our sheets are "missing". This is what we see when we click "manage automation workflows" We're also unable to create new workflow. Smartsheet Gov Status shows no issues with workflows. Is anyone else experiencing this issue?
Hi. I have been the System Admin for the past 2 years. When I came into this role, I added our logo under the setting in Branding & Personalization. Our logo has now changed and I need to update it. However, when I go to Branding & Personalization the only options I have are Profile Visibility and Working Days. Did…
