-
Retrieve value from "Top Parent" when Ancestor level = 2
I have a project management sheet. CSYYXXXX is the header for the project name column Tasks is the tasks column - at the parent row, I just write "Tasks" and then there are child rows below that. Some of these child rows and another level of descendant rows. I want a column formula (to serve as a helper column for various…
-
#Incorrect Argument Set
Hello, I am having issues with a formula and am hoping that someone can help. I am trying to tie two separate columns (Project Percentage and Days Remaining) to automate a project status column. I am getting an incorrect argument set error. Not Started = Project percentage is 0% Complete = Project percentage is 100% On…
-
How to add varying months to varying dates?
I am really having trouble getting a formula to work here. I've gone through a number of support articles, but I'm just missing something. I want a formula that looks at Date Contract Executed and it adds Months Until Expiration to produce a new Date of Expiration. I've got my date columns as dates and the middle column as…
-
New Column Type: Time
In Sept 2023(ish), Smartsheet introduced a TIME function. To further utilize this function, a new column type should be added, called "Time." This column type will function similarly to the "Date" column type in that it will only accept values formatted in a specific way and, most importantly, can be used to trigger…
-
Automatic Phase from WorkBreakdown
Hello all! I'm modifying the Simple Portfolio Work Breakdown Schedule and having a little trouble. I like the way the Work Breakdown structure works but I'd really like an automatic way to track which Phase something is in. I know I could just add a column and manually select which Phase tasks and sub tasks are in, but I'm…
-
Column Formula Help - Helper Checkbox for Shift Entries
Hello Community, I am looking for some help with a helper column checkbox formula needed to support reporting of data to a dashboard and downstream formulas. I have four shifts (A,B,C,D) entering data points into a sheet, with the potential for multiple line entries occurring per shift per day worked (see example below). I…
-
Find and Replace Function in Formulas
Having the ability to find and replace items in formulas would be incredibly helpful and save time as we update certain sheets each year.
-
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…
-
Formula to bring back the 3rd Friday of next month
I need to calculate the 3rd Friday of each month consecutively on a sheet. I am looking for a formula that will take the date of the previous line and spit out the next month's 3rd Friday, in sequence. Any help would be very appreciated! Thank you.
-
Locking in results from a formula
I have a sheet that each ROW is a monthly store visit. I have a column that counts the number of visits each store has and add that number to a unique store visit ID…. example Store 123 visits= 3 then the store visit ID would be: store123-3 Every thing has been working fine, it is great because you can always tell how many…
