-
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…
-
Names in column brought over to Column titled after name?
Hello! Sorry for the confusing title. I have a sheet that users will manually input %'s into. The sheet has 3 columns, Task #, Names, and %. I basically want to send over the %'s into another sheet that tracks everybody's % based on the Task # and who's name is in the "Names" Column. Sheet 1 Sheet 2 So I want to create a…
-
Form not auto populating fields if one column cell contains a comma
I'm using a form that when triggered, populates several fields from a source sheet then posts to a another sheet. I've noticed that if the column titled "Description" has a comma in the text of a cell, such as image 1 below, then the form will not auto populate all of the fields that I want. It will also stop populating…