-
Calculating Next Monday, Wednesday, Friday
I'm trying to write a formula to calculate the next monday, wednesday, and friday following a particular date. The AI formula generated =IF(ISDATE([Start Date]@row), [Start Date]@row + (8 - WEEKDAY([Start Date]@row, 2)), "") using the example above; however, it generated an #INCORRECT ARGUMENT error. The expected results…
-
Health Icon Formula Help
Hi All - Longtime lurker, first time poster. I am attempting to add a Health Column to a smartsheet created by a colleague. I have been in the forums checking answers to similar, and tried to kluge my own formula together, but I've either missed the logic or I'm trying to do too much. What i'm trying to achieve rollup…
-
COUNTIFS question
EDIT - I think I solved my original problem by removing the <> before the "2099". However, how do I write the formula to show not equal to 2099 without using an operator? SS doesn't seem to like it when I use <>. ******Hi, I've browsed a number of the COUNTIFS posts but for some reason, I can't get my formula to work. It…
-
VLOOKUP No Longer works with same formula
This worked right before New Year's. Now for some reason it says Incorrect Argument Set?=VLOOKUP(Email@row, {RRFP Sales Log 2025 Total Cost}, 13, false) Basically I have the clients' email in the Primary Column for Smarthseet 1 and 2. I sheet 2 is RRFP Sales Log 2025 and Total Cost is the name of Column I need pulled from…
-
Percent formula for drop down fields
I have a column with the following options for drop down fields: NA, Not Started, Required, Drafted, Posted What formula can I use to show me % complete (posted) without taking into account the NAs?
-
2025 Free Smartsheet Webinars/Office Hours
I hope everyone is having a great start to their year! I am posting here because I wanted to share the schedule for the Smartsheet Webinars we will be hosting this year. Here’s a breakdown of the schedule for the first half of this year: Office Hours: Starting in February, our Customer Success Manager, Lisette Planken,…
-
How do I copy the info from the cell above if criteria are met in another column?
What I would like to do is create a formula that will copy the information in the cell above it if the 'X-code Details' is chosen in the pick list in the column next to it. If General Run Details is indicated, want the entry to remain. I know there has got to be an easy solution to this, I just can't find it and AI is not…
-
New! TIME function for formulas
Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…
-
COUNTIF Formula Returns Zero in Sheet Summary
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The formula should be: =COUNTIF([Tablet Year]:[Tablet Year], 2017) I've also tried surrounding the "2017" in quotation marks in case…
-
Within the last 12 months
I can't get my formula to pull violations reported only within the last 12 months. Can someone see what I am missing? =COUNTIFS({Compliance Master File V2 EE-number}, [EE Number]@row, {Compliance Master File - Compliance Category}, "Reinstatement"), AND({Compliance Master File V2 Violation Date}<=[Today]@row, @{Compliance…
