-
Recent Submission Formula
Hello, My goal is to create a formula that will automatically update the current status of our utility systems based on the submission of the most recent inspection form. Basically, I'm looking to create a green dot on a separate sheet if ARU1 and ARU2 are both online and both temperatures are in spec (I can provide the…
-
Pulling most recent values from form submission
Hi Community, I'm attempting to pull a value from a cell based on the most recent form submission. The information I'm trying to pull is from the below: I'm looking for a formula to collect the value from from the "Visually Inspect ARU1 HMI/ verify systems in auto" column based on the most recent submission (Row 1). I've…
-
Getting Message Column Formula Syntax Isn't Right
Hello, I have the formula below that works, but when I try to "convert to a column formula", I get the error. Does anyone have any ideas why? Thank you! =IF([Date & Time]@row = $[Date & Time]$2, "8:30 AM - 9:45 AM", IF([Date & Time]@row = $[Date & Time]$3, "3:30 PM - 4:45 PM"))
-
Trouble with VLOOKUP syntax error in some, but not all, column formula selections
Hello, I am having some inconsistencies with turning VLOOKUP function into a column formula within the same sheet, I am using VLOOKUP in three different columns. One of the columns allows me to turn it into a "column formula", but the other two give me a syntax error (SEE last and final photo for error message). See screen…
-
Formula under Duration in a Gant chart
Hi there, I'm new to smartsheet I want to switch from MS Project to smartsheet to set up the planning schedule. I know we can assign multiple of people to a task but at the planning/biding level, I just want to juggle with the number of resources to set the best outline. I would like to set the work (total effort to…
-
Vlookup a cell with a formula
Hello everyone, I am trying to use a normal Vlookup function in smartsheet. The search_value (number) and also the value that is supposed to be looked up in the look_up table (same number) are also pulled with other formulas. If I hardcode the numbers instead of suing a formula, then the Vlookup works. Does this mean that…
-
Summing rows if columns are checked using cross-sheet reference
Hello, This is the formula I've tried but it is giving me an "unparseable" error. =SUMIF({Tracer Site List -Revenue/Project Complete},[Project Complete]:[Project Complete], 1, [Licensing Fee]:[Licensing Fee]) Thank you for your assistance!
-
Formula Help
Hello, I am trying to figure out a formula that would function as such: Column B will pull a data value from another Smartsheet based on the matching data point in Column A. Column A 123 Column B (Based on what is in column A, will insert data value XYZ from Other Smartsheet) Other Smartsheet Column A 123 Column B XYZ…
-
TotalFloat inconsistency between parent and child tasks
I am looking to utilize TotalFloat in a project plan and am finding inconsistent results with parent and children tasks. The sheet is set to Mon-Fri working days with no holidays set. The formula in use is =TOTALFLOAT([Task Name]@row) + " days" From what I am seeing: -The manually calculated delta between Line 14 and Line…
-
WORKDAY formula to prevent auto planning on weekend days
In my sheet I would like to use a date and add 3 days automatically in another cell, but I want to make sure the date that automatically appears is not on a Sunday or Saturday. I have looked in the Formula Sheet which is provided by Smartsheets, but can only find formulas which calculate the amount of workdays between two…