-
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…
-
Count a Range of Dates IF the box is checked
There are columns to the right (columns names 1 to 32) that have dates in them that increase incrementally. Here's my sheet.... the column "Number of Appt btwn 3/1 and 12/31/20" has the following formula: =COUNTIFS([1]@row:[32]@row, IFERROR((@cell), 0) >= DATE(2020, 3, 1), [1]@row:[32]@row, IFERROR((@cell), 0) <=…
-
Calculating Fuel Consumption
Hi there, I manage a transport fleet and want to use Smartsheet to track the vehicles' fuel consumption. It is calculated by subtracting the kilometres from the previous fill-up from the current fill and dividing this variance by the litres of the current fill-up. See attached spreadsheet. The problem is that fuel fill-up…
-
Add an Alt-Enter to a Formula?
I have a formula that is pulling a status update from 3 different sheets: =IFERROR("BA: " + INDEX({ITBA Status}, MATCH($[Project / Task ID]@row, {ITBA PID}, 0)), "") + IFERROR(" AppDev: " + INDEX({Dev Status}, MATCH($[Project / Task ID]@row, {Dev PID1}, 0)), "") + IFERROR(" CS: " + INDEX({CSStatus}, MATCH($[Project / Task…
-
How to order rows from a Auto Number/System column?
Hi I have a sheet A (SA) that is populated by copying row from sheet B (SB). When a new row is added to SB, I have a "Created" column set up as Auto Number/System column (System-generated column =Created (Date) ) which allows me to identify when the row has been added. I want to filter the rows based on the dates they have…
-
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…
-
Automated emails look
Hello, I have my sheets set up right now to automatically send out an email with an attachment when a box is checked. I have received complaints that the emails look to formal and or spam like. Especially when the sender is "Your name" via smartsheets. Do we have any way to change the look and or sender information? We…
-
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…
-
Combining AND & OR in a formula
I have a sheet with the following three columns: --Was the question asked --Answer 1 y/n --Answer 2 y/n I want the formula to turn the flag red (cell already formatted for flags) if the question was asked, and either answer 1 or answer 2 were no (aka, i need all the no's from everyone who was asked the question). So far I…
-
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…