-
Nested IF Statement Formula
Hello Team, This would be a great formula to incorporate into my daily SmartSheets process within my organization. I would like to know how to create a nested IF statement if this is the correct formula to use, that uses an RYG (red, yellow, green) light flag formula to set the status of a task based on its…
-
Resource allocation with multiple assigned to
Good day all, I'm working with resource allocation across multiple projects. Resource allocation is turned on for the account and then turn on and off for each sheet I want in the overall program. My understanding is that %allocation is assumed to be at 100% when there's no %allocation column specifying otherwise. In our…
-
Health Ball Color Based on Dates and % Complete
We are utilizing the RYGB properties for our Health column and trying to improve the tracking of each task using this criteria: * If a task has NOT started and no progress has been made, no color indicator * If a task has started and is not late, but progress has been made, green color indicator * If a task is 100%…
-
Adding row number to email sending attachment
We frequently send attachments to the next task owner (example, from document drafter to document editor), and we want the person receiving the attachment to know in which row the attachment is posted. Is there a way to do this? Right now the email just has a link to the doc.
-
Not getting notifications today
Not getting notifications today
-
Formula
HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…
-
Rows deleted when deleting columns connected to formatting
Hello smartsheet community, Initially I was tracking completed tasks with a "Done" column which would automatically format the row. After needing to add more options like "Cancelled", "In Progress" etc. I opted to create separate column which contains those options. After clearing all of the "Done" column formatting I went…
-
Export to MS Project (XML) - Greyed out
The function - Export to MS Project (XML) - is no longer working Has it been taken out of my subscription and have to upgrade or someting?
-
Overwriting Lines?!?
Is anybody having issues with people overwriting each other in their shared sheets? We have (3) users utilizing the same sheet and adding in lines at any given time and we started to experience some refreshing issues. It just happened again today as a line I created 2 hours ago was overwritten by another user AFTER they…
-
Filtering/Slicing in Dashbaords
Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter/slice the data in the dashboard view, say to specific users or anything like that (for example, I can see total sales…