-
Formula help
I need assistance with a formula. Trying to create if/and statement for a checkbox. =IF(AND([Trigger for Parent]@row = TODAY(), [Submission Status]@row = ISBLANK, 1, 0)) If the Trigger for Parent column = today AND the Submission Status column ISBLANK Check the box
-
COUNTIF Between Date Range
Hello, I am trying to see how many projects were completed in in 2021. I have several different dates and years within the column, but I'm looking for a count of all projects with a 2021 date. The below formula is what I'm using but I am getting #UNPARSEABLE. =COUNTIFS([NOC Recorded Date]:[NOC Recorded Date], >=DATE(2021,…
-
Timeline Variance indicators
Hi, I am new to using Smartsheet and was wanted to confirm a few things timelines related: Can Smartsheet create predecessor and successor dependencies (FF, FS, SS, SF) similar to MS Project? Does Smartsheet allow for WBS elements to be created through indent / outdent similar to MS Project? Can Smartsheet allow linking to…
-
Running Balances for employees
Hello all, I am trying to make a spreadsheet that tracks employee fitness reimbursement balances based off of their entries into a form. Each employee has exactly $300 that they can use per year for fitness expenses. Every time they submit a reimbursement, it gets put into a form that includes their name, clock ID, date,…
-
Is there a way to Add Filters to Pivot Tables?
Hi - I'm in the process of creating a "Request Tracker" sheet with associated reports & pivots to serve up to a dashboard. I want to create a pie chart that breaks down "Request Type" but only for open requests (meaning, the Status is not one of "Completed" or "Cancelled"). So my question is, is there a way for me to…
-
Can you use a form to allow users to select available time slot
We are trying to utilize a smartsheet form for recipients to select a time slot for a specific training we are doing. We are offering a training to some internal folks but are limited in seats for each session. There are 12 sessions, some on the same date just at different times. Will use form to - * Allow recipient to…
-
Date formula to reference another cell
Good Morning! I'm seting up a metrics spreadsheet with a lot of formulas. The person who will be administering it in the future isn't really familiar with formulas so I'd like to make it as easy as possible. I created a formula that does what I need =COUNTIFS({Date Reported}, >=DATE(2018, 11, 26), {Date Closed},…
-
Matching & Indexing formula for rating actual against target based on a scale
I'm trying to write a formula for Balanced score card assessment to award a 'rating' against a target that then translates to points and based on the points how much bonus is received. I'm writing the formula as below: =IF([2022 Actual]6 = 0, 0, IF([2022 Actual]6 < [Scale 2]6, [Scale 2]8, IF([2022 Actual]6 >= [Scale 4]6,…
-
Column Formula Changes - Change Cell Value
Hi Community, I have a column that contains a column-formula it has 3 options/ratings: "1-Great", "2-Not Good", "3-Bad", I set up an Automation that if it changes to 2 or 3 it should check a box in another checkbox column, but this is not working. I have another Automation that if it changes to a 2 or 3 it alerts soneone,…
-
Conditionally changing cells
Hi, I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value. I know that the changed to functionality is available through automation, however the action options in automation do not offer cell changing…