-
=IF statement not recognizing two cells as matched
Using this formula to check if two values in the same row match, and returning "Yes", "No", or "Hold" to display the associated symbols. =IF(ISBLANK([Column A]@row), "Hold", IF([Column A]@row = [Column B]@row, "Yes", "No")) If they match it returns "yes": green checkmark If they both have values but they don't match it…
-
Formula to generate the expiration date, 1 year after date signed?
I am trying to figure out a formula that can generate the "expiration" date based on the "date last signed". The "expiration" date is one year from "date last signed". Note, dependencies are off. Example: If the "Date Last Signed" is 01/01/20 then the "Expiration" date should be 01/01/21. Seems pretty straight forward but…
-
Why can't I convert =IF(COUNTIF(Email:Email, Email1) > 1, 1) to a Column Formula?
Brand new to this app. My formula: The error: Where that link takes me:
-
Help with date formula's
I am creating a tracker that will keep track of vacation days, and the number of days an employee gets each year depends on how long they have been an employee. The days are earned each year on their anniversary. I have almost everything working with the exception of 1 thing. Let's say I have an employee that started…
-
Conditional formatting on a cell that has multiple date input from a form
Help needed and much appreciated!!! I have a built a form to track new contracts, I input the data manually and one of the options are upgrades. The upgrade field in the form is a drop-down multi select option and I would like a different column to automatically calculate the price based on the options selected. Is is it…
-
COUNTIFS PARENT cross reference
In my summary sheet, I need to cross reference the PARENT rows in my data sheet (status) to count the number of open non-conformities (with less than 100% complete). Basically, the counting in summary sheet needs to take into consideration two conditions in the status sheet: Be a PARENT row, and % complete <1 I have tried…
-
Actual % Complete vs. On Schedule % Complete
Hope everyone is doing well? I'm looking for a formula or suggestions to accomplish the following: IF “On schedule % Complete is > Actual % Complete then the task is “Late”, “Red Ball”. IF “On schedule % Complete is < Actual % Complete then the task is “On track”, “Green Ball”. IF “On schedule % Complete is = 0% (Actual %…
-
Formula on Smartsheets not autopopulating
I have a Smartsheet that has formulas setup in the first two rows of the sheet. I have data on an Excel that needs to be copied and pasted onto this sheet. On copying and pasting upto 20 rows, Smartsheet has continued to maintain the formulas without any issue. However if I copied more than 20 rows, the formulas dont seem…
-
Keeping formulas when pasting rows of data
I',m in a bit of a pickle with one of our sheets. So right now I've got a sheet that is being filled in automatically with a script that I made. It is taking a CSV that is constantly growing, converting it into an excel doc, and then copying & pasting the entire thing into a smartsheet. This works great for the most part,…
-
Issue with Formula Autofill
Hello, I am currently trying to make an equation driven total column. Currently I am experiencing issues with the formula not autofilling to the next row. I have looked at the help page that describes the necessary criteria for autofill to take place. I plan on filling this sheet via a form and so far have been testing…