-
Locating the parent of a parent
I am trying to take the value from the primary column of a level 0 parent and insert it into another column in a level 2 child. =PARENT([Task Name]@row) works fine when there is only level 0 and level 1. Something like parent of a parent is what I have imagined would work, but =parent(PARENT([Task Name]@row)) is…
-
Find and Replace in Formulas
Hello, I use a TON of formulas that involve employee names. When creating sheets for new employees I need to paste the names into each formula. It takes FOREVER because I cannot find and replace within the formulas. Am I missing something? Also, how do I stop this from happening? I can't make a column "number only" so I…
-
Formula to add 1 day to date
I'm having trouble with a formula to add one day to a date based on a condition. I'm sure it is something terribly simple that I'm just missing right now. My formula worked previously when I had AND in the formula with two conditions, but when I only have one condition it adds a 1 to the end of the date rather than adding…
-
COUNTIF Formula for Checkbox Column Not Working in Sheet Summary
I'm trying to create a formula in the Sheet Summary that shows the number of checked items in a Checkbox column named Pending, out of the total number of rows that have either a checked or unchecked box (i.e., excluding blanks). =COUNTIF([Pending]:[Pending], 1) + "/" + (COUNTIF([Pending]:[Pending], 1) +…
-
Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…
-
VALUE RETURNING AS BLANK
I have a data sheet with several items listed and their referenced codes. On another sheet I have a form whereby my engineers can select from a dropdown list the item and whereby, based on their selection, the code should publish in an adjacent cell. The formula I use works for the first item on the dropdown list but the…
-
Limit to Multiple Formulas-All IF statements.
Can you help me write a formula that has 10 different conditions and references multiple columns on the same smartsheet? I've utized the AI tool to assist me but when I get to the 7th formula, it cannot compute.
-
Formula to Turn Number into Date
Hi Smartsheeters! We currently have another system feeding dates into Smartsheet in a number form. For instace, this number (1695686400000) is sent to Smartsheet represents 9/26/2023. How can we convert that number into a date value in Smartsheet? Thank you for your help!
-
Assistance with Formula for 30-Minute Meeting Reminder
Hi all, I need assistance with a formula where I want the box to check 30 minutes prior to the meeting, but I’m hitting a roadblock. The "Start Date" is a Text Column. Below is the formula I’ve tried: Start Date Helper Formula: =IF(ABS(NOW() - (DATE( VALUE(LEFT([Start Date]@row, 4)), VALUE(MID([Start Date]@row, 6, 2)),…
-
Assistance with Conditional Progress Formula Referencing Only One Column
I’m trying to create a formula that dynamically calculates progress based on the value in a Status column. In some cases, I want the formula to preserve the existing progress value when the status changes to “Pending” — essentially freezing the value that was previously calculated. However, since I only have one column…