-
Getting value from Parent column
In the example below, I have a column named "Task Name" which contains "Version 1.0" and a column named "prefix" which contains "1.0" In the row Task A, I want to pull in the value "1.0". I was hoping to reference it by using =PARENT() Can someone show me how to do that? I have had no luck. =PARENT() provides a reference,…
-
FORMULA - Estimated vs Actual Time
FORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF Not, shows "UP" Symbol. Times are entered in minutes (00.00) Thanks in advance! This is what I currently have: =IF(AND([Actual…
-
RYGB automation with date and status
Okay first off I did not write this syntax I copied and pasted from another post. It works to a point but I need it to be a little more detailed and I cannot figure it out. Here is the syntax: =IF(Status1 = "Complete", "Blue", IF([Start Date]1 = TODAY(), "Green", IF(AND([Start Date]1 < TODAY(), Status1 = "Warning"),…
-
adding conditions to recurring reminder formula
I'm trying to expand on this formula that triggers a recurring reminder (explained here: https://www.smartsheet.com/blog/support-tip-recurring-reminders): =IF([Flag1]1 = 1, TODAY(), "") I want the return value to equal today if the flag is checked and another date cell is in the past. I tried a bunch of variations and made…
-
SUMIF using dates
I'm trying to use the SUMIF function to calculate the total in Column A when the date in Column B is less than or equal to 10/2/17, but haven't been able to make it work. Please advise.
-
Need help with getting parent and sub parent data
I have a format that looks like this Project Name PreCon Name Name Construction Name I am looking for a formula that adds text to a column for each name structured as "Project Name - PreCon" or "Project Name - Construction" I can get it to work using explicit references =PARENT([Task Name]13) + " " + PARENT([Task Name]14)…
-
Help with date formula
Need formula to calculate a date: Spreadsheet has (3) Columns as follows: Cal Type (drop down) with 2 options - In-house or Third-Party Next Cal Date: Date Reminder Date: Date Would like formula to calculate the following If/then scenario: If value in Cal Type is "Third Party" then need Reminder Date to be Next Cal Date -…
-
How to count a text in a column?
Hey there, I'm trying to count a specific initials in a column with multi initials in each cell, but it doesn't work. Please check out the image. Is that a limitation? Thanks.
-
Formula Suggestion: [Column Name]@ to Imply "[Column Name] in This Row"
In Excel 2010, a simple and powerful feature was added to formulas used within tables: the @ prefix. All @Column1 means is this row in Column 1. It greatly simplifies the reading of formulas, and I would wager that accross the entire spectrum of Smartsheet users, most formulas are referring to cells within their own row.…
-
Date Formula Reminders
If you set up a date on a formula, can Smartsheet still use a reminder. The questions is here that actual text in the date field is a formula displaying a date. The items are not showing up on the calendar and that is concerning. Thank you in advance.
