-
NETWORKDAYS formula
I am trying to calculate days open between the request date and today and not count weekends however I want the count to start at 0, not 1. I am using the below formula but for everything with today as the request date, it is showing -2. Once it moves to tomorrow, the days open goes back to 1. How do I get rid of the -2?…
-
Has Function
I'm struggling with the HAS Function. I think understand how it works, but I can't get the syntax right or something. Here it is: I'm trying to count the number of times each of these Values is selected in a cross sheet reference. I'm using {EXP} as the column reference. I'm using the formula below in the table below, and…
-
Automatically calculate % Complete based on Dates
Request to improve % Complete column formula. Currently provided % Complete column formula will never be accurate if you also have identified Milestones since Milestones are only identified if Duration = 0, so % Complete will never show 100% for the associated Parent Rows. Currently provided % Complete column/column…
-
Auto delete rows flagged as duplicate or missing
I have a 2-part question: Setup - we use a master sheet that uses data mesh to populate 3 other sheets based on a primary key. This works well. However, there is alot of manual cleanup. part 1 - If a row is deleted from the main sheet, I would like it removed from the other 3 vs. me highlighting it for manual deletion, an…
-
How to delete cells when a column has been converted to a formula column
Hello, I am taking the course through (SmSh Uni), Writing Formulas in Smartsheet - Self Paced. I am completing an activity given to convert a formula in a cell to a column formula. The tutorial says there will be errors in two children rows and that I can delete the two cells. Unfortunately, you can not delete a cell when…
-
CONTAINS with several criteria
We are trying to calculate several criteria and pull into our metrics My problem is when i am looking for Airline, the Airline range has several criteria in 1 cell, how do i look for CONTAINS? I tried different ways to calculate it but i keep getting errors =COUNTIFS({Amadeus: TC Known Issues & Limitations Mas Range 2},…
-
Any idea what I could be doing wrong?
Hi all, I need to create a formula that will collect info from a different (original project) sheet and display the right data on the cell of a new sheet (used to build a report) - that way things stay updated as the project progresses. So, a couple of things need to be taken into account, the info displayed needs to meet…
-
Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. I've never used the TIME function before, but I'm hoping I can use this to try and save having to add multiple helper…
-
Trying to increment a value by 1 each day, based on a specific status. - GOV
Each day that a row is in an 'In Progress" status, I want to increment a counter to determine the # of days in progress. So far I have tried an automation that runs daily and filters based on the condition. But I am not finding a way to add 1 to the counter. I have thought about doing a function but can't find a suitable…
-
Highlighting Past Due Items for Different Dates
I’m looking for a way to highlight when a date exceeds 5 business days without explicitly setting due dates. For example, if I enter a submission date as 2/3, how can I automatically highlight it as past due on 2/10? Any suggestions on how to track this in Smartsheet? Each line has a different request with different…