-
IF BLANK Formula
Hi I am trying to input a formula to calculate 3 months from a date in another column but, I don't want a #invalid date error showing in that column when there is no start date. I've tried using the following formula: =IF(ISBLANK(DATE([Start Date]@row, MONTH([Start Date]@row) + 3, DAY([Start Date]@row)), " ")) But, I get a…
-
Automation just for one row
Hallo, very beginner user and have a question I couldn't find an answer to in the community. I have set up a monthly to-do list with automation that is sending a reminder to a person outside of the company to provide a file. Trigger for the automation is reaching the "Due Date" with the condition "Done-Check" = unchecked.…
-
Estimated Capacity Calculation
Hi All, I am running an estimated capacity calculation on Smartsheet, the raw data (=attendance tracker) is also stored on Smartsheet & the pages are linked to each other via references. I am using for the calculation headcount and the average of the monthly target, the only problem is that from the available headcount not…
-
COUNTIFS for assigned to CONTAINING a name
I'm trying to total the numbers of active assignments assigned to a person in a cell that can have muliple selections. .... it's not giving me an error but coming back as 0 =COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("name", @cell), Status:Status, <>"completed") Anyone help!?
-
Hi I'm trying to convert a formula to a column formula but get an error message
I'm using below formula, what is wrong in it, anybody got a clue? =IF(NOT(ISBLANK([Completion Date]@row)); 5; IF([Target Completion Date]@row >= TODAY(); 1; IF([Target Completion Date]@row >= TODAY(-14); 2; IF([Target Completion Date]@row < TODAY(-14); 3)))) Thanks Hilbert
-
Automate SLA, Days Column
Hello. Is it possible to automate the SLA, Days column using the conditions on the 1st three columns? The 1st three columns are with dropdown list. So when they choose an Item Description and Responsible column the SLA, Days column will automate the day value. Thank you!
-
Using INDEX to get Project Plan data dynamically
Hello everyone, I would like to ask if there is a way to extract data from Summary or the Sheet at itself using some kind of INDEX formulas. The use case is that we have an Intake Project Sheet that generates an automatic ID (https://share.getcloudapp.com/DOu2DQgD). Once the project is approved, we generate a project plan.…
-
Parent/grand-parent rows in reports
Hello! I have tried to follow steps in other posts, but my brain cannot figure it out :) Could anyone help me identify the helper formulas for pulling parent cells into a report? I need to pull in to a report the Goals and Problem Statements for any Projects that are identified as "Must Have". So I am trying to figure out…
-
How do I exclude a cell with checkbox from formula for a specific row?
I'm trying to use the COUNTIF statement to total a range in a row with checkboxes that are selected and provide the percentage of what was checked. That part worked (highlighted in screenshot): =COUNTIF([Thumbnail Image Rec'd]6:[Migration Complete]6, 1) / COUNT([Thumbnail Image Rec'd]6:[Migration Complete]6) The issue is I…
-
% Complete Children tasks on several hierarchy levels minus tasks that are N/A
Drop down options are N/A, Not Started, In Progress - On Track, In Progress - At Risks, Complete. I want if children tasks are marked complete I want a % to calculate for those tasks marked complete minus N/A tasks. Parent = 100% (correct) Child 1 - Complete Child 2 - Complete Child 3 - Complete Child 4 - Complete Child 5…
