-
Can two date columns feed the same calculated column depending on which one is answered?
I have a date column that is prepopulated based on a connection to another sheet of current employees. From this, I have calculated the number of days since an event. If these employees are no longer in my connected sheet, this date becomes a #No Match. I've created a second column of manual entry dates for these…
-
Create a dashboard widget to count project status by quarter.
Hello everyone. I am a project manager using Smartsheet for the first time in a new organization. I would like to create a widget on our PMO dashboard to display the amount of "New" and "Closed" projects in our system by quarter. Our data is pulled into an intake sheet via a form. My approach is to pull data into a…
-
Comma in the wrong place on one user's view only
I have a really strange problem. I have column formatted for US currency, and there is a comma in the wrong place only on one user's view. My view looks fine. I have deleted his access and reshared, reformatted the underlying sheet and everything else I could think of, but it's still in the wrong place. He has Editor…
-
Count multiple values in a single cell
Hello. I'm very new to Smartsheet and a complete novice with functions. I can get by with bountiful resources in this community. I can't seem to find any other instance of the question I have about contact column conditional formatting. I hope it's possible. Ultimately, I want to apply conditional formatting to a cell when…
-
Multi-Select Count Criteria
Hello, I want to count all Small projects where the Top 12 multi-select column has any value populated. The multi-select Top 12 column will have many blanks. =COUNTIFS({All Projects}, "Small", {Top 12}, OR(....) Thanks, Amy
-
Create Date - Modified Date= Time Spent
Hello, Can you help me with the formula for "Time Spent" Column. I need to calculate how long it would take to process the order. Sometimes we process for days. I need to know how many days, hours or minutes. Thank you so much.
-
Workflow - Notification
We use a workflow to send instructions to a contact, when a box is checked in a column. Each message is customized with information from the corresponding row - and should be sent separately. Somehow, the system sent two messages with customized content in a single email, and changed the subject line to be "(2 entries)"…
-
Is it possible to add a link to a smartsheet item as view only?
I have one master sheet (my department overview) into which I want to add links to dashboards in multiple other workspaces (one per project). I have one row per project and it is very simple to right click, add hyperlink and choose smartsheet item, then simply select the workspace and dashboard for the project. However, I…
-
Formula help - count of a value from a multi-select dropdown field
I have a column in a sheet that is a multi select drop down containing people's names. I then want to count the number of cells that contain a particular name - whether it's the only name listed or is one of the names in the cell. Can someone help me with what formula to use? This formula is only counting the cells that…
-
IFERROR Formula to Resolve #DIVIDE BY ZERO Error
Hello, I am familiar with how to use the IFERROR function but for some reason with the specific formula below I am continuing to receive the #DIVIDE BY ZERO error message. I hope I am just missing a small detail with this and it can be resolved. =IFERROR(INDEX({Global GREF Project Tracker Range 3}, MATCH([Building…
