-
If a cell does not contain a period
Looking for the syntax for if a cell does not contain . (a period) This is not working =IF([Work #]1 <> "*.*", "No", "Yes")
-
Formula to populate a cell from 1 of many populated columns
I have 5 columns. Only 1 of the 5 will ever be populated per row I need help with a formula to populate a cell with the value of the column that has a value. I tried =([Cell1]@row+[Cell2]@row+[Cell3]@row+[Cell4]@row+[Cell5]@row) It seems to work but it gives me a leading zero
-
Baseline/Actual Schedule formula help
Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additional rows with "Actual Start" and "Actual Finish". When I enter dates into those rows, I'm looking for them…
-
Nested VLOOKUP statement error
I am receiving an error with the following nested VLOOKUP statement. I've included an image that might help to better explain. Unfortunately, I have looked at this so many times and tried so many combinations that I'm afraid it is a simple fix that I am just not seeing. Need to use the number in Details4 cell (in this case…
-
Nest an IF Formula
With the help of the community, I have two formulas that I would like to combine into one if possible. Formula 1 =IF(Ancestors@row = 0, COUNTIF(Ancestors$1:Ancestors@row, Ancestors@row = 0), "") Formula 2 =IF(LEN(RowID@row) = 1, "000" + RowID@row, IF(LEN(RowID@row) = 2, "00" + RowID@row, IF(LEN(RowID@row) = 3, "0"…
-
Finding duplicates numbers
I have been trying to build a formula that will find duplicate numbers. Most solutions that I found in the community will only work for text. Can anyone help with finding what I'm doing wrong. The formula shown on my screenshot is the same the entire column. Cells highlighted yellow should show as a duplicate.
-
Formula HELP!
Hi! I am looking for a way to make my report of action items look better. I want to add a column that automatically can make my report look like the screenshot (attached). Does anyone know a formula that could help me? Thanks in advance!
-
Sending Multiple lines for Approval at one time
Hi, has anyone figured out a way to send an approval request for more than one row at a time? I have rows that all need approved that need to be sent in the approval request along with their information, much like a daily notification of changes, however in approval request form. Currently we are able to send for approval…
-
Contact Formatted Cell --> Autopopulate Info into another cell.
How can I get a cell that is formatted as a Contact List to populate a cell to the right with a phone number, email, or other static attribute when a select different contacts? Our assigned to items can change quite frequently, and it would be great to autocomplete contact info in the next cell automatically. Thanks.
-
Auto change status to complete based on start/finish date?
Hello, I've looked through the forums but can't seem to find a formula that works. My columns are status (Not Started, In Progress, Completed, and ERROR). I need the status column to reflect what is input into the start/finish date ex: start date today end date blank = In Progress. I also want to display an ERROR message…