-
Frustrated
Hi All - I am new to Smartsheets and I'm attempting to teach myself as I go. I created a sheet for every department that also has a form attached with specific questions to be answered. Department managers will use the form link provided to input their information daily. I am struggling with how to get these metrics to…
-
Workflow Automations being sent out on a different levels of data within Intake Sheet
Hi all, I'm trying to solve an obstacle I came across when building Notifications in the Intake Sheet. Let me shortly describe what I'm trying to achieve: Above is an example of the Intake Sheet that will act as a scenario for my question. I have a Primary column, which is a combination of different values from two columns…
-
COUNTIFS formula not functioning how I expect
Hello, I am expecting this formula to count the number of cells in the "FND Prepare" column that have a certain name in them, where the cell on the same row in "Prepare Status" is not green. =COUNTIFS([FND Prepare]:[FND Prepare], HAS(@cell, "NAME"), [Prepared Status]:[Prepared Status], (@cell <> "Green")) Does someone have…
-
Rich Text Format in Sheet Cells
We have been converting all our projects to Smartsheet and now have about 86 projects loaded. A big issue for us is, (I would like to know how many other people would want this) we have a column in our status reports that go to our VP's called "Status Comments". The VP's are used to seeing comments with bullet points,…
-
Sorting date via the Grouped-by parameter
In the Report associated with our Dashboard, Smartsheet doesn't seem to allow us to sort by the 'Request Status' columns (which is a Drop-Down menu on the Form and Sheet). Is there a Work-Around? We want these displayed in a particular order based on which step the order is in, based on the Request Status. Thanks for any…
-
Date Formula to return following Monday or Wednesday
Hi everyone, I need help with another date formula. For this one, we have a system entry that needs to be done which will trigger the "Expected live date". I currently have a "Task" column and a "Due Date" column. Here's how it should work but realize the timing may be impossible to capture... 1) If the system entry was…
-
Why would you save a sheet as a template vs saving as a new sheet?
I have a master sheet that I plan to replicate multiple times retaining all configuration I have done ie workflows, attachments, predecessors. It appears that saving as a template and saving as a new sheet would retain all of those features. So what is the benefit of saving as a template vs saving as a new sheet (and vice…
-
Please add a Wildcard Function
Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.
-
Sheet with Mapped Column No Longer Working
I'm having issues with a sheet that has a column mapping users for a filtered report. The sheet has two columns - PDS Selected that captures sign-ins where session hosts are selected, and PDS for View, a column that maps to PDS Selected and is formatted as a Contact List. This then filters to a report set to Current User.…
-
Change Date based on Symbol
Good day everyone, I've seen a lot of posts about changing a symbol based on the date, but none for the other way around. In my use case, I have a Priority symbol that is being filled in on a form. I need to create a due date based on the Priority chosen and the date the form was entered. I was able to build that initial…