-
How to create dependent drop down lists?
based on the choice selected on this drop down list, the next column should have a dependent drop down list (based on the choice in the previous column's choice).
-
Logging modified date/time of data in a column
Hi you all. I'm currently in the process of analazing some trends in a particular operation and one of the most valuable sources of data would be the ability to extract the modifications log for every cell on a particular column in a spreadsheet. So far I've looked for such functionality over the site but can't seem to…
-
Calculation for Variance in Percentage between Target column and YTD Column
Hello Community; I'm building a dashboard to reflect how different projects/programs are tracking towards targets. I want to showcase the following: 1) Projects that have gone above their targets, 2) Projects that didn't meet the target, 3) Projects On track to meeting the targets. I've already tried this formula…
-
Numbering rows
Hi, I wanted to know if its possible to have the entry number as the Function + RAID item(R,A,I,D) + number. For example, if its risk 1, in function 1, I want the entry number as "Function 1. R.1" and if its Issue 3 in function 3, the entry number should be displayed as "Funciton 3. I.3" and so on. Please help. Thanks!…
-
Update Status and Progress of an activity based on Actual Start and End Date
Hi , I am relatively new to smart-sheet and would require assistance in setting up formulas for my POW Sheet .I would like to have my status column of an activity to be updated based on the actual start and End Date Start Date = Blank Status to be updated as Not Started (Red) Start Date is not Blank and End Date = Blank ;…
-
I need to create a conditional COUNTIF formula
I need to count the dates from a separate sheet that occurred in today's week number. The following function works if I choose a range of date fields that are not blank. =COUNTIF({RANGE}, WEEKNUMBER(@cell) = WEEKNUMBER(TODAY())). However, if I choose a range that includes date fields that are blank, it returns "Invalid…
-
My form submissions won't pull the formulas from the sheet.
Hi, I have a sheet that I am using to manage goal/task tracking for my team. I have some formulas to calculate %completion based on how many boxes are checked in a row and a join formula for another purpose. I am trying to break this sheet down by project and am using parent/child rows to achieve this. The first row is a…
-
ROLLING 30 DAY AVERAGE SHEET SUMMARY
Hello, I'm looking to build a formula in the Sheet Summary that will provide a rolling 30 day average from the PROD values. (attached is a data subset) Feels like this should be fairly basic, but am struggling to find the solution. Anyone's help would be appreciated.
-
Index,match,match
I'm having the hardest trouble figuring this part out. Even after doing some searching and people asking for the same thing. When i try to use it on my sheet it doesn't work. I want to do excel's version of index,match,match. I've tried index(collect), join(collect), max(collect), but i am doing something wrong apparently.…
-
CountIF for a multi-select drop-down
Hello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because it makes the most sense for me. In the sheet summary tab, I want to be able to count how many rows need…