Community

I'm trying to create an IF statement that relies on the data in 2 cells.  Basically, if one cell is checked off and the other is empty, I want to create a formula on a new cell (which I will hide) so I can ultimately send an update request to the user to fill in the notes field.  I haven't used the

Do placeholders - {{ column-name }} work in

I have a hierarchy of checkboxes.  I am trying create a IF(AND) formula to at the Level 1 checkbox to be checked once all the Level 2 boxes are checked.  I am able to make it work when I reference each of the cells , for example:  =IF(AND([Map Complete]18= 1, [Map Complete]19 = 1, [Map Complete]20 =

I'm trying to create a formula that will automate the RYG balls (red, yellow, green) based on the project's % Complete. 

Green = 100%

Yellow = 50-99%

Red is = 0-50%

Below is how I wrote the formula, but I'm getting a Unparseable errors. 

**Note, I'm trying to enter the formula into the Status column

I am trying to send notifications based on multiple cell data but the default is set to "or when".  I need both variables to be met before sending the notifications.  I would hope this is easy and I am just not seeing

I'm not sure how to automatically enter a value of zero if a cell is empty.  Is this possible?

I tried to enter the formula below (and various iterations of it) but I get errors.  The error for below was "unparseable".

=IF([% Complete]1:[% Complete]17, ISBLANK, ("0"))

Anyone know if this is

Hi Community—

Need some advice.

My team uses an Excel spreadsheet to track account updates. Weekly we add a column to the right and the team inputs a paragraph of text. So the existing Excel sheet is up to column "AH" since we are at calendar week W42. So next week ... "AI" and so on. The previous

Greetings,

I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer".  I tried modified date but that field gets changed too often to accurately reflect the state.  Essentially, I want to know how many widgets were issued by date they were issued without

Hi,

I have noticed that the criteria for sending update requests to an individual in a 'contacts' column can be set for a specific date, but I am looking for the ability to send a routine monthly reminders/updates to these individuals on a recurring basis.

It appears the functionality for routine

Why is the 'Sharing Status' sometimes in bold green and sometimes in regular black text? Why does each text format