-
Combining 2 Formulas
Hi, I have a column that is calculating today minus a date that is in another column. I have another column that is taking the days and converting it to weeks. Then i have another column that is taking the weeks and rounding down to 1 decimal point. Is there a way to combine the column converting to weeks and the column…
-
Help with Vlookup + date
I explain, I need to create an expiration date from a drop-down menu where the different types of payments of my clients are informed. Example, if a customer's account is "up to date" it means that the due date will be the issue date + 0. Also if another customer has a "credit" deferred payment type, the due date must be…
-
Count Rows that are Open and Closed based with another condition
Hello, I tried to do a search here, but could not find what I was looking for. I have a sheet with each row being opened and closed with a date range. I would like to count the rows that have an open date but no closed date, and also count rows that have the closed date populated with any date. I also need to add a…
-
count open days
I need to count how many days have passed since an answer appeared I have the date column I have been reading on using the WORKDAY formula But I get the wrong argument = WORKDAY ([DATE] 11.5 How can I do to count the days? they work 5 days a week regards
-
At Risk formula help
Hello, I need help with creating a 'At Risk flag' when End Date is reached and Status is not complete. I have tried multiple combinations, can someone please review and help me correct this formula I am entering on Row4, End Date and Status are columns and Complete is a drop down under the status column. =IF(AND[End Date]4…
-
Identifying Duplicates within a column
Does anyone know how i can do this? it seems that SmartSheet does not have the ability to do this as in Excel.
-
Nested Crtiteria
Hi, I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria. =COUNTIFS({Status}, @cell <> $[Primary Column]7, {Owner}, @cell = "Erica" + COUNTIFS({Status}, @cell <> $[Primary…
-
Status for At Risk tasks due in 7 days
I have 4 status categories for my project with respective RYGB balls: * Complete (blue) * At Risk (red) * Requires Attention (yellow) * On Track (green) My current formula in the Health column automatically changes the RYGB balls when the status is changed manually: =IF(Status2 = "On Track", "Green", IF(Status2 =…
-
Help with Auto-populating dates
Hi All, I have been trying to figure out how to auto-populate dates. I've figured out that if I enter a date, type in the desired duration of when I'd like the task due, it populates the due date for me. All of that seems like it's project in the future and I'm running into this particular problem. Let's say I need to…
-
Calculating a column based on date
I'm trying to total up the job value column based on weekly totals. Can I have the formula calculate the weeknumber or do I have to create a helper column?