-
Pulling from 2 different sheets into one sheet
I am trying to pull project phases from one Smartsheet and project checklist items from another sheet into one sheet. I would like the information from both sheets to be on the same line in the destination sheet. (Report puts them on two lines) Below is my current formula and I received the error #Incorrect Argument Set
-
Index/Match
Hello when matching between two smartsheets using this formula =INDEX({Livestock Transferred on Range 3}, MATCH(nlisid@row , {Livestock Transferred on Range 4})) it sometimes returns #NO MATCH even when there is the same exact data in nlisid to match to, they are both dropdowns. Out of 909 lines 59 are not working…
-
Generate formulas using AI in table view
October, 07, 2025 Table view now supports generating formulas using AI, previously only available in grid view. With this feature, you can quickly create working formulas in the formula panel without needing to master complex functions or syntax. Simply describe what you want the formula to do in plain language, and AI…
-
Logic for parent row status
I have a to do list with parent tasks and children tasks. I have a status column with a dropdown menu with the options “Not started,” “In process,” and “Completed.” I want to have a formula that auto-populates the parent task with the status based on the children tasks. Here is the logic that I want the formula to use: If…
-
Using SUM with child rows
I have a parent row that I'm using to sum all child row values where Children = 0 and Status = "Not Started". This is my formula. =IF(OR(ISBLANK(Status@row ), Hierarchy@row = 0), "", IF(Hierarchy@row = 1, SUM(CHILDREN()), IF(AND(Children@row = 0, Status@row = "Not Started"), 1, 0))) However, if any of my task rows are…
-
How to link to data in one sheet and transpose the data in a new shieet
I have a sheet that has data displayed both horizontal and vertical. The primary data is horizontal (date) with information below each date, 4 rows of data. After the data the dates for the next set of data is horizontal with information below it vertical. 1/5/26 1/12/26 1/19/26 1/26/26 JP OS TT LL OS RT RR SS That data…
-
Writing Formulas in Smartsheet - Self Paced - Optional Activity
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
-
help with auto numbering my projects that have children and grandchildren
I want to assign project numbers to the main project, and then append that project number with .(letter) for the Subprojects, with Tasks still being assigned to the main project number, with the letter of the Subproject, and adding more hierarchy, such as I'd like the task to read 40.c.1, or something similar that…
-
Countifs formula to count based on two columns
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
-
Cut-off Date
Hello I am looking to create a Smartsheet formula that returns the following result: Column A "Created Date" - this column type is a Created date and show results with date and time Column B "Received Date" - this column would round up the "Created Date" and just show date, no time. If the "Created Date" was after 2:00pm…