-
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.
-
Combine 2 IF formulas
Hi, Can someone help me with combining these 2 formulas? =IF(MONTH([Date Raised]12) = MONTH([Date Raised]1), "Yes", "No") and =IF(YEAR([Date Raised]12) = YEAR([Date Raised]1), "Yes", "No") Regards, Samad
-
Counting rows between two sets of dates
Hi Smartsheet Community, I'm trying to figure out how to count a row if the date column falls between a set of dates. Basically, I'd like to use the COUNTIF formula and count the row if the date is between 07/01/17-09/30/17. Any ideas on how to do this? I'd rather not add in an additional check box, just base the formula…
-
Help With Formulas
I am attempting to automate the RYG column shown in the screen shot below. I need the formula to look at the finish date and status columns if the status is not "Done". I need some feedback on the formula that I am using below. =IF([Finish]1 < TODAY(), "Red", IF([Finish]1 = TODAY(), "Yellow", IF([Finish]1 > TODAY(),…
