Formulas and Functions
Archives for March 2020
Discussion List
-
Functionality QuestionIn Formulas and FunctionsHello, 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…
-
Sheet Summary Report Grand total row ?In Formulas and FunctionsI 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 fo…
-
COUNTIFS in a multi-select contact columnIn Formulas and FunctionsI 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 valueIn Formulas and Functions=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 wo…
-
Missing Source Data on DashboardIn Formulas and FunctionsI 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?Answered - Pending Review 52 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Formula from One Column to autopopulate other column dropdownIn Formulas and FunctionsHi 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&quo…Answered - Pending Review 21 views 1 comment 0 points Most recent by Debbie Sawyer Formulas and Functions
-
Automation unsubscribed the creator automaticallyIn Formulas and FunctionsHi 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…Answered - Pending Review 13 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
SUMIF with OR functionIn Formulas and FunctionsHello! =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, {We…
-
If Status = "DNR Request - Approved" or "MRS Request Approved" Then formula question...In Formulas and FunctionsIn 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 = &q…Answered - Pending Review 11 views 2 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Sequential Unique identifier for two types of records in a sheetIn Formulas and FunctionsHello 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 thi…Answered - Pending Review 75 views 4 comments 0 points Most recent by Andrée Starå Formulas and Functions