-
Adding Days to a Date Based on a Condition
Hi I've trawled the forum for previous questions but can't seem to see one similar to what I need. I have a date column that I want to auto calculate based on a condition within another column. If [Corrective actions to be completed] = "Immediate" or "5 working days", take [Corrective action chaser 1] + 11 days, if…
-
Adding networkdays to a date to get a future date
Hi. I have a Finish date in my programme and I have a given Networkdays number. When I add the Networkdays to the Finish date in order to return to a new Finish Date, the formula returns #INCORRECT ARGUMENT error. Please help.
-
Conditional Formula for date
Hi Everyone, I want help regarding the conditional formula for a date. I would like to change the color of the cell color if the date is 90 days before today. If it's possible please guide me. thanks in advance
-
Populate Q1, Q2, etc with IF function not working
Hi there, I currently have a formula that is working for Q1 & Q2, but for some reason, it is not working for Q3 & Q4. I am at a loss as to why this is not working properly. Any ideas? =IF(MONTH([End Training Date]@row) < 4, "Q1", IF(MONTH([End Training Date]@row) < 7, "Q2", IF(MONTH([End Training Date]@row), 10 <"Q3",…
-
Trying to enter a formula in a field of a parent row that will count children w/specific values
Hi all, Fairly new to smartsheet and I am trying to set up a formula in a parent row with a single select drop down column "Status" that will count the children that show one of three specific values in the column: So if the cell drop down choices in the Status column are: Submitted Interviewed Offered Declined Withdrew…
-
Multiply cells in single row if cell is not blank
Referencing the attached image, I want to multiply the Pricing cell by the Seats/Multiplier cell, but only if the latter has a value/is not blank (obviously irrespective of row, ignore that part in the formulas). So if this works: =Pricing13 * [Seats/Multiplier]13 And this works: =IF(ISBLANK([Seats/Multiplier]2), Pricing2)…
-
Help with formula with multiple conditions to auto-update RYG ball
I am trying to create a formula with multiple conditions in order to automatically change the color of the RYG ball. IF the Status = Not Started/In Progress/Blank AND the End Date is less than TODAY () then the ball should be Red OR IF the Status = Not Started/In Progress/Blank AND the End Date is in the next 7 days then…
-
Pull data from one sheet into another using Index / match / contains
Hi everyone. I have two sheets and need to pull from one to the other. One sheet lists widgets and data about them, the second lists press releases and includes {press release tracking Range 2}, which is a column listing all of the widgets listed in that press release. So, the widget sheet is: Widget Press release…
-
Multiple IFs combined with Countm formula
Greetings, I'm currently attempting to write a formula to provide variable outputs based on a Countm function(column in my smartsheet that has multiple dropdown options). What I'm looking to do is have a single formula that will take the result of a Countm on my "corporate objectives" and output a percentage. In the…
-
Formula to count multiple columns with multiple drop-down options
Hello, I'm trying to develop a formula to count the number of issues being tracked by a priority, by a status, and by a submitting team. For example, I want to count the number of items have a priority of "Low" (in the priority column), a status of either "Open", "On Hold" (status column), or "Escalated", and was submitted…