I need help with creating a 'At Risk flag' when End Date is reached and Status is not complete. I have tried multiple combinations, can someone please review and help me correct this formula
I am entering on Row4, End Date and Status are columns and Complete is a drop down under the status
Working on implementing a basic webhook based smartsheet connector to fetch usage data for users under one organization. During the Oauth2.0 flow, requested for following scopes "READ_USERS, ADMIN_USERS, ADMIN_WEBHOOKS".
I am currently working on automating an "Assigned To" column based on postal codes. There are multiple postal codes options per individual with three individuals. Is there a way to create a (albeit very long) formula to populate? I'm currently working with
=IF(OR([Postal Code]@row = "01xxx-09xxx",
So I have a user that is leaving the company in a couple of weeks. She is the owner of sheets and workspaces. She wants me to transfer ownership to another user. Not a big deal we can do that. My question is, if I do that now how will that affect her now? I'm going to leave her as a licensed user.
Is there a way or setting where I can control how email alerts are sent when multiple rows match the criteria? For a while, even if multiple rows matched the criteria, we would always get individual emails/alerts for each row. (i.e. 6 row match criteria = 6 emails). However, after the recent update,
I'm trying to have Smartsheet create a list of unique data *without* using Reports. Help (-: In the Names table in the screenshot, you can see that there are names manually entered a number of times in random order. That is fine and good. What I'm trying to do is is have a second sheet have a "Names
Has anyone had any issues with someone not receiving email notifications on certain sheets? Or receiving the email notification and the comment not showing up in the sheet? It looks like a glitch happened to one of our sheets on August 29 and I wanted to see if anyone else had the same issue. It