-
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…
-
How to register a cell in a Text/Number column as a date in a formula?
I have a formula from Excel that I'm trying to duplicate in SmartSheet. The formula references row1 which is a month-year (eg JAN-20). This is a duplicate for the column name so it can be interacted with in a formula. So there are 2 elements here that I need help with. Can treat a cell from a text/number column as a Date?…
-
Countifs
Hi, I am trying to count the number of entries in multiple columns between dates in another column in a metrics sheet. Here is what i am trying however i am getting a error. =COUNTIFS(Design Services Projec Range 12}, {Design Services Project Range 4}, >=DATE(2020, 1, 1), {Design Services Project Range 4}, <=DATE(2020, 1,…
-
Automate RYG For Project Tasks
Hi All i am very new to SmartSheet. I am working on the project template which can help to highlight some tasks that have been overdue with RYG. Need your kindly help on the formula... 1. If task status is complete: Green 2. If the task status is Not Started: 1. Scheduled End Date is behind today: Grey. 2. Scheduled End…