-
Functionality Question
Hello, I am more of an Excel guy who is attempting to wrap my head around Smartsheet. I have a scenario and I am thinking it can be done, it seems like I almost find the answer but just not quite. I have records which require attention, usually in contacting users and getting require, late training complete. There are a…
-
Sheet Summary Report Grand total row ?
I am bringing in 2 separate sheets into a sheet summary report using a custom column called "Total Revenue" which is a sum of each individual sheet's revenue rows The sheet summary report is showing correctly both rows for each sheet and the corresponding totals for each sheet. e.g. Miami $138,875 Tampa $264 My question is…
-
COUNTIFS in a multi-select contact column
I am trying to count the number of times a name appears in a multi-select contact column, however, none of the proposed formulas are working. Please advise. Thank you! Wendy
-
How to find a word and return a value
=IF([Trip Purpose]@row=(FIND"Morning"),"2-Day",IF[Trip Purpose]=(FIND"Afternoon"),"3-Swing",IF[Trip Purpose]=(FIND"Night"),"1-Grave", "Float") I'm trying to find the work Morning, Afternoon, or Night from a phrase in a cell in the Trip Purpose Column and then make the new column (Shift/) to return the corresponding value…
-
Missing Source Data on Dashboard
I was just in my Dashboard and saw all of my charts and graphs. Now, when I log back-in, I am getting a Missing Source Data on my Dashboard. How can I recover?
-
Formula from One Column to autopopulate other column dropdown
Hi Need help with a formula. When "Yes" is selected manually in the Incidents Safety or Medical column (this has a manual drop down of Yes or No, I would like it to If "Yes" selected the "GS&S Incident Case" Column to auto-populate with "Yes - Enter Case Number" and If "No" selected the "GS&S Incident Case" Column to…
-
Automation unsubscribed the creator automatically
Hi Guys. I encountered with something very strange in SS automation process I created, and I couldn't find a response to what I have been experiencing.I created a simple automation workflow that does the following: once the value in one of the cells reaches a certain value a mail will be sent to my personal mail. The short…
-
SUMIF with OR function
Hello! =COUNTIFS({Weekly Shop Visit Update Range 10}, >=[Start Date]17, {Weekly Shop Visit Update Range 10}, <=[End Date]17, {Weekly Shop Visit Update Range 7}, "M56-B", {Weekly Shop Visit Update Range 8}, [Column30]$2, {Weekly Shop Visit Update Range 88}, "HEAVY/PRSV/LLP") How do I create options where {Weekly Shop Visit…
-
If Status = "DNR Request - Approved" or "MRS Request Approved" Then formula question...
In an effort to track the amount of time from submission to completion I'd like to have a formula help populate the [Actual Completion Date] by using the following logical expression...however I'm not getting this to work. If Status = "DNR Request - Approved" or "MRS Request Approved" then [Actual Completion Date] =…
-
Sequential Unique identifier for two types of records in a sheet
Hello Smartsheet community. I am in need of a solution that allows me to leverage an intake form to track Objectives and Key Results. I need to be able to sequentially generate unique ID's for each Objective and for each KR and I need this to not break with sorting. The reason is, I need to do lookups on the Unique…