-
Approval Workflow - Request approval from a pre-defined contact in a sheet
I have a use case where the approver for something will not always be the same individual. I would like to add a column for the approver (contacts list), and have an automated approval workflow that sends an approval request to the individual listed in that column. Smartsheet seems to require that I specify a single…
-
IF(OR(Find Statement
I am trying to build a formula that searches in a column for a certain word using FIND( and I would like to add OR to that. I am using this formula and it is working fine: =LEFT([Address]@row, FIND("TZ", [Address]@row) - 1) I would like to add FIND("GZ" so that it returns either after finding "TZ" or "GZ" Thank you!
-
Dashboard Line Chart - Automatically Update
I have a Dashboard created with a Line Chart in place that plots simple data points 'as of' a certain date. I have a Data Shuttle that updates the source sheet each Friday with a new data point. Is there a way to get the Line Chart to automatically recognize that a new row / data point was added to the source sheet?…
-
Creating an automated report
Hi, It's me again. Today I would like to ask if it is possible for reports to automatically select items that meet all the requirements of a set criteria. What I would like to do is make it so that when a task is completed and the box is check, that that task is added to the report and displayed on a dashboard. Is this…
-
Text to Columns: Getting rid of letters in between numbers
Hello, I have this date in this form 2022-08-21T02:04:38Z and I am trying to get rid of the letters 'T' and 'Z' in the middle of the date. Thanks.
-
SUMIF Formula with Checkbox Criteria
Hello, I used to be able to use a sumif formula and pull in lines values that had a check box in one reference column or not checked in another reference column, and now that formula I used in the past doesn't work, I would use ...,{column Reference}, TRUE... ...,{column Reference}, FALSE... I can get around the issue with…
-
Can't add a column to a sheet
I have the paid version (for years) of Smartsheet. For some reason on one of my sheets, I cannot add a column. Any help? Thanks! Jennifer
-
Countifs forumla with 3 criteria's
I'm have used a countifs formula to count the total number of jobs per month that have been launched in my business using the following formula: =COUNTIFS({Project Launch Input 2021+ Range 3}, >=DATE(2022, 6, 1), {Project Launch Input 2021+ Range 3}, <=DATE(2022, 6, 31)) I now what to be able to count the number of jobs…
-
Countifs in date range and value range.
I am stuck on this formula, it doesn't become unparseable but it doesn't result in an accurate count. My goal with this is to is to keep an annual tally of a specific age range of patient the formula is as follows: =COUNTIFS({Trauma Chart Audit Age}, <15) + COUNTIFS({Trauma Chart Audit Age}, NOT(ISNUMBER(@cell)), {Trauma…
-
Help with sorting numbers and letters that are combined in one cell?
I would like to sort by a column that has both numbers and letters in a cell. Such as 1, 1a, 1b, 1c. Right now if I sort it by it by the ascending option, it's able to do 1a, 1b, and 1c correctly, however it separates it from the numbers that don't have any letters. For example: This is what it does: 1 2 3 1a 1b 2a 2c 3b…
