-
Help on Intake Form
I am wanting to use the Project Management Office Template to create a PO System Template instead. On the Intake Sheet I can change the column headers. But I cannot change the First Row Title Cells. They are tied to the Metadata Sheet in the Template. I want to know how to change these to reflect the titles I need, such as…
-
Remove spaces from text string
In a column that I've titled File Name, I've created a =JOIN formula that merges multiple columns of information to generate a consistent set of file names. One of the columns that is being merged shows the title of an item with spaces between words (e.g., in the Title column, one of the titles reads: Curriculum…
-
SUMIFS returns a $0 (s/b an amount) once there are Oct 2022 & 2023 entries in a date range
Aloha, I have a SUMIFS formula that works until I have Oct 2022 and Oct 2023 entries in the date range. Then Oct 2023 returns a $0 when it should return an amount. I have tried reversing the month and year in order in the formula and it still returns a $0, any help would be appreciated. =SUMIFS(Price33:Price174, [Expected…
-
Formula for IFERROR(Index(Collect based on 3 different unique columns.
Good Morning Smartsheet Community, Current Formula: =IFERROR(INDEX(COLLECT({Pass/Fail}, {Sales Order Number}, @cell = SO@row, {Unit Part Number}, @cell = Part@row), 1), "") Possible New Formula: =IFERROR(INDEX(COLLECT({Pass/Fail}, {Sales Order Number}, @cell = SO@row, {Unit Part Number}, @cell = Part@row, {Line Number},…
-
Need help with function to add Date and Number value to derive a Date
Hi Smartsheet Community! I need help with creating a function that can use a Date value in parent row and add a number value in child row and calculate a Date. I've tried to capture the scenario in below screenshot. Is this even a possibility? Could someone please help? Thanks!
-
VLookup returning values from a different row
I'm stumped on this one. I'm running the following formula: =VLOOKUP("In Progress", [Phase - Task]:[Phase Status], 1) 1st column in the table is Phase - Task. VLookup finds the value "In Progress" on row 6 in the Phase status column, but then returns the value from Phase - Task from row 4. I've never seen VLookup pull data…
-
Hello, I'm trying to write an IF statement, but I can't seem to figure it out.
Here's what I'm trying to do: I have a column (Truck Fee) that needs to equal another column (Total Labor) IF column Labor Type = On-Site. I've read multiple posts that are similar to my situation and some that aren't and still can't seem to get it right. I've been using (formula being put in "truck fee" column):…
-
INDEX using MAX(COLLECT)
Hi Smartsheet Fam, I have the below sheet: I have a second "helper sheet" that looks exactly like this with a rule set up: any time "MVE Increase Recommended" changes to "yes", copy the row to the helper sheet. I have this set up so I can capture a snapshot of the person who updated the "MVE Increase Recommended" cell…
-
How can I combine two formulas to bring back more detailed results
I am currently using formula =IF([Status]@row = “Complete”, “Complete”, IF([Due Date]@row < TODAY(), "Past Due", IF(AND([Due Date]@row >= TODAY(), [Due Date]@row < TODAY(+7)), "At Risk", "On Track"))) In an effort to populate the Overdue Status column on my Smartsheet with the status of Complete if the task row is marked…
-
Share score with person that completed quiz
So I have all my formulas set to calculate the score on an 8-question quiz. Is there a way to automatically share the score with the participant once they submit their answers?
