-
Change the date to a new date in the future when met the criteria
Hi, I curretnly have a smarthsheet that consistit of giving reminders and follow-ups for some actions. I am looking for a formula that basically (IF the due date column is less and the done column is checked, then change the due date for 2 months after. Thank You
-
Display a Dash "-" when dollar value = $0 for accounting sheets/data
I have been asked by a business owner to display a dash "-" instead of a $0 value. It is a helpful way to eliminate business from a sheet/report/dashboard for 0 values.
-
Problem with nested IF/CONTAINS for Multi-Select Column and Zeros
Hi all, How do I get rid of the zeros in this formula? (And why does it seem to work fine for Monday and Tuesday only selections?!!?) Below is the text of the formula and it is citing a multi-select column. Class Days Short is a text/number column. =IF(CONTAINS("Monday", [Class Days]@row), "M, ") + IF(CONTAINS("Tuesday",…
-
Return Header Based on Last Column Populated
I'm trying to figure out a formula to add a date to a particular cell, then return the 'header' value in another cell. Ideally it's a formula automated to find the last populated cell of a row, then return the 'header' of that column. Sample situation: with the 4/1 date populated here, I want the empty green cell to read…
-
Link a column from one sheet to another sheet.
I have a detailed sheet which I input a wide range of information useful for my usecase, but I want to make a summary sheet that only shows certain columns to a 3rd party so they can just see the information that they need. I need new rows of information to automatically link to the summary sheet when new entries are made.…
-
Generate sequential numbers base on task column
Hello everyone, Hope you are doing well! How can I generate sequential numbers base on task column that has parent and child tasks, where each parent task has three child tasks, and each child task has one sub task. Please find below screenshot for better understanding & for now I have filled this sequence manually, I want…
-
JOIN/COLLECT multiple checkboxes into a text/number column
Hi all, Using Paul Newcome' solution in this post, I came up with the following working formula: =JOIN(COLLECT($[Add to ABE waitlist]$1:$[Add to Transitions waitlist]$1, [Add to ABE waitlist]@row:[Add to Transitions waitlist]@row, @cell = 1), " AND ") But I can't convert it to a column formula because of the absolute…
-
Summing $ from Multi-select dropdown that includes text
I am running into a problem that I have not been able to find in the community. I have a multi-select dropdown column that includes text and $ values, e.g. A - $25.00, B - $30.00, etc... I would like to take the selection from the column and sum the $ values. I would then multiply that by the Qty, =( )* Qty@row. I am able…
-
Extracting the Time from the timestamp
The question relates to extracting the Time from the timestamp when the "Column Type" is "Auto-Number/System" and the the "System-generated Column" is "Created (Date)" your assistance is greatly appreciated
-
Greater Than - Less Than Formula
Smartsheet Community: Im trying to get a result of In Progress when % Complete is greater than 0 but less than 100. Current Formula: =IF(AND([% Complete]@row > 0, [% Complete]@row < 1, "In Progress"), IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete")))) I am not sure where my error is. All Help…
