-
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,…
-
Filter data on dashboard report
Hello! I have a report listing application statuses (approved, in process, declined) and agreement statuses (executed, in process, canceled) as a widget on my dashboard, and one of team members would like the ability filter by status. Is this something possible to do?
-
How to count and rank top 10 from one column of data
Hello. I am trying to create some KPIs in Smartsheet and roll up to a dashboard. In a column I have a running bid board with customers listed ("Customer Name") as the bids accumulate. In a separate sheet where I am rolling up KPI calculations I want a live count of how many bids (or instances) that customer is listed in…
-
How do I automatically populate a summary row at top of sheet with latest non-blank information
I have a sheet with a Release Date and then four additional columns, each column representing a different piece of software. I want a user to be able to add a new row and only populate the Release date and the new version of software they have released. I want the top row to automatically populate the latest, non-blank…
-
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,…
-
Changes since last week
Hello, Is there a way to show changes since last week to a 'date' column? I don't want to highlight the change, I want to be able to see if the date moved since last week and then calculate the number of days it moved (eg: +10) I don't want to right click and view cell history either. I want to show a simple report/project…
-
How to make the cell blank if the other cells used in my formula are blank?
Hi everyone, I'm new to using formulas in SmartSheet. I currently have a formula for one of my rows which works properly (thanks to the help of a member here!): "=IF(GLP@row <> "YES", IF([Expiration Date]@row < TODAY(), "YES", "NO"), IF([Expiration Date]@row < TODAY(-365), "YES", "NO"))" (Basically, the cell marks "YES" if…
