-
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?
-
Can someone suggest where I'm going wrong with my formula
Hello All I'm fairly new to Smartsheet, and I believe my formula is correct, in all rows but 1 it is functioning properly. If I re-enter that information in the "bad" row into a new row it still flags incorrectly. The bad rows total 567.79 clearly under the 3999.. but still flags Red. The formula =IF(TEC@row < "3999",…
-
Populate Contact List Column with Value from Another Table With Date Condition
I want to populate cells in a Contact List column that is used in workflow automations based on a formula that pulls the contact(s) from another sheet. Sheet fields: Resource(s) (type Contact List that allows multiple contacts per cell) Start Date (type Date) End Date (type Date) Position (drop down - single select) My…
-
Returning a Date Value from Another Sheet if Certain Criterias are Met
I have been working on the formula to return a date value from another worksheet if certain criterias are met. Here is the formula i input but with a formula error of #UNPARSEABLE =INDEX(COLLECT({Send Out Date}, {Range}, =CONTAINS("Bank Confirmation", {Range}), {Client ID1}, =CONTAINS([Client ID]@row, {Client ID1}))),1)…
-
Remove a string of characters after a special charater :
Need a formula to remove "Account name" from the Use case name. Right now the format in the use case column is Account Name: Use case Name I want the "use case column" to only have the use case. I tried the below formula but getting a circular reference error. Please advice. Thank you. =LEFT([Use case: Name]@row + ":",…
