-
Combine IF formulas in one cell
Hello, I'm trying to create a %Complete column based on a drop down list column called "Status". For example, I'm looking to combine these formulas into one cell, then copy and paste to all other cells in the same column. I'm very new at this and cannot figure it out. If there is a better way top accomplish what I'm after,…
-
Criteria for Alerts and Actions Rule
My boss has a Smartsheet set up to send a Update Request 30 days before today. For example row 7 would look like ....=[Due_Date]7 - TODAY() Would this alert still be sent if Smartsheet was down for maintenance at the scheduled time the alert was to be sent, or if there were conflicting "work week/full week" settings?…
-
Formula Help
Hello New user needing help with formula. I would like it to be something like this: When the due date is => than today -1 turn red, if the due date is < today - 3 days turn yellow, if due date is is =. than today +5 turn green The idea is if a task is due today or tomorrow its red, if a task is due within 3-5 days its…
-
Feature Request: Switch, Vlookup, and/or Lookup Functions
Please add one or more of the following functions: switch, vlookup, and/or lookup. Note that this would make it easier to reference rate categories in a rate table without having to use a huge nested if function.
-
Assistance with a formula -- similar to VLookup
I’m not sure if this is possible in Smartsheet but I know the Community will know! For our Annual Meeting, I created a blank sheet that will help us manage our schedule and assigned meeting rooms. Some of the columns are: * Meeting Room Name (the name of the hotel meeting room) * Capacity-Conference (the capacity of the…
-
Column Status Formula
Hi Everyone, I have a status column with the following options: Not Started, In-progress, Complete, N/A. I've created a formula if the parent row is set at 'Not Started' then the sub-task would automatically change to 'Not Started'. Same with Complete and N/A. In-progress needs to work a little differently. The parent row…
-
Parent Sum IF
I've tried a variety of calculations, and can't seem to get the results I'm seeking. I'm simply trying to add up all of the parent rows in a column called Resource Days that are Assigned To a specific team member. Any suggestions? =SUMIFS(PARENT(Resource Days:Resource Days), [Assigned To]:[Assigned To], "Team Member")
-
Enhancement Request: Report Criteria What? on Dropdown column like Text/Number
When I have a Dropdown column for the What? criteria of a Report, my only option is some version of the "is one of" criteria. What I want is to be able to build the criteria like a Text/Number column, for example using "contains" Use Case: I have a drop down list like this: Building 1 Building 2 Building 3 Building 4…
-
New Lookup Function
New Formulas =lookup() Find the corresponding value of data by row. For example, look up a price of an automotive part by the part number. In this release you will only be able to do lookups on the same sheet as the =lookup() formula. Until this function is usable across sheets, it is basically worthless.
-
Count & AVG only if another column contains "text"
Hi Again, After scouring discussion boards I have managed to Average the total of the rows, see below =IF((COUNT([Days to respond]194:[Days to respond]214)) = (COUNTIF([Days to respond]194:[Days to respond]214, 0)), 0, SUM([Days to respond]194:[Days to respond]214) / ((COUNT([Days to respond]194:[Days to respond]214))))…