-
Duration Including Weekends
Hello! We have our project (task tracker) set to exclude weekends, which is what we need as we don't want anything due on the weekend. However, we need a duration column that includes all days between the start and end date, not just the business days. How can I do this? It's currently showing the duration of business days…
-
Float between task and it's successor
Hi, There doesn't seem to be any clear way to calculate the float between two tasks. If I have task A and task B, and task A is a predecessor to task B, I'm looking for a formula to calculate the amount of time task A can be delayed. Has anyone found a method to do this? TOTALFLOAT is not useful on my projects, it often…
-
Count if a cell has two values
I'm trying to count if a cell has the values of either 'Yes' or 'No' but am getting an 'Unparseable' error. =COUNTIF([Description Format(correct format)]:[Description Format(correct format)],OR(@cell=“Yes”,@cell=“No”)) Help! Thanks in advance!
-
Custom Auto Numbering Function
Hi! New Smartsheet user here, appreciate any help and guidance. I'm looking to create a formula to build a custom auto-number function. I'm including a screenshot for reference. I'd like to automate the Project ID column. Where the project ID is YEAR - CLIENT - CLIENT PROJECT NUMBER. Is there a formula out there that would…
-
Using IF with more than 3 items
Hi, I gotten so much help here before, so once again... I have a column Total Rank Score where we assign points to each task. I want to be able to group those into 3 categories. If value is between 0 and 7 = "Low", if between between 7 to 10= Medium , If over 10 points ="High" =IF([Total Rank Score]@row <= 7, "LOW",…
-
Use a cell reference as a criteria in sumif and countif formulas
I have a set of data, as shown below, and I am using formulas to pull data from the columns nights, ADR and total. I am using COUNTIFS and SUMIS formulas to collect the data, which are working well. The issue I have is that I need to replicate this data and tables for multiple different buildings and units. Right now I am…
-
Integrate lookup list (vlookup?) with if statement
I have a lookup list of Councils and the towns they cover. On another sheet, I will be writing something like "the team will visit TOWN A". I want a formula to examine that statement and draw through the corresponding Council from the look up list. Can I write a formula in Smartsheet to achieve this, noting that there are…
-
Trying to create a formula that determines the current season
I've got a formula that generates the current quarter and one that calculates the current year. Now I'm trying to write an IF statement that creates a value that says S23 by reading if its Q1 or Q2 and then adding the 23 from the current year (2023). This is my current formula, can anyone explain why it's not working or…
-
COUNTIF or IF Statement
I am looking to add date columns that are based on a criteria in another cell. I can use the COUNTIF statement to add the dates but when I place an criteria in place I get an error. =COUNTIF([Due Date]:[Due Date], <=TODAY()) This works to count my dates that are less then or equal today but I need it also to filter out if…
-
How can I send automated updates to submitters?
I am setting up an automation for my client and am having trouble sending out automated messages and wondered if someone could help me with a solution. Here's the structure: Sheet 1: Reports are submitted monthly to sheet 1. (The submitters are not allowed to see the data in the workspace.) Approvers review the information…
