-
COUNTIFS across columns with multiple options for one column
I am trying to write a formula to count the number of columns across five nonadjacent columns that contain "Verified". The fifth column may contain "N/A" and also needs to be counted. In the example, 5 should be the total count for both rows. I've tried adding multiple COUNTIFS, and it doesn't work. Thanks in advance for…
-
Creating Archive Files In Smartsheet
While rewriting my 2016 Smartsheet application that tracks all sorts of weekly and monthly data on projects and employee billable hours charges, I needed to be able to store those results in archive files for use by various sheets and reports that use that data. Automated workflows allow that data to be copied to another…
-
Quarterly Budget with SUMIF
Good Morning, I am trying to use the SUMIF function to pull data from another sheet. =SUMIFS({Budget Requests Range 1}, {Budget Requests Range 2}, "Software", {Q/Y Lookup}, [Q/Y]@row, "") The other content is: Budget Amount (Budget Requests Range 1) Type of Request (Budget Requests Range 2) Q/Y that the budget applies to…
-
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…
-
Max out Cross sheet reference ?
I have an error message "unable to create cross sheet reference because this sheet already contains the maximum number of different cross sheet references." How to resolve this issue? I already deleted many rows to reduce the cross reference but didn't work.
-
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…