-
Weekly progress report - project related
Hi , Need a help of team. complex one :- I have Project Plan sheet for following data below screenshot 1 I want to create a report based on status and weekly progress % Complete as shown in Screen 2 to create a dashboard chart as shown in 3 to show it in dashboard.. Can you help me on it. Also, this weekly progress report…
-
Number of day to complete less weekends
I am currently using the formula below to calculate the number of days to complete a task. Is there a way to exclude weekends. (option 1), and possibly a custom list of holidays (option 2)? =[Resolved Date]@row - [Created Date]@row
-
Date Regenerating
Hello, is there a way to have information associated with a date to regenerate Every so often? For Example, we have a sheet that has an expiration date "Designation Expiration" and all the information after that is related to falling within that time period. We would like to have all of that information repopulate Every…
-
Convert String/Text to Date Object
I have a piece of text that is coming through as 2021-06-15T00:00:00Z and I need to parse this as 06/15/2021 and convert it a Date object so that comparisons can be made on it. How would I achieve that?
-
Copying Rows To the Top of Another Sheet
Hi All - Is there any way to use the Copy function, from one sheet to another, and have it copy to the Top of the sheet it's going to?
-
Stuck in #UNPARSEABLE
I have a column titled "Department" for which there are multiple departments listed I have another column with a specific set of numbers, 0-4. What I am attempting to do is count the number of instances of 0-4 based on a specific department. I have tried this formula in multiple ways and I cannot get it to work. Latest…
-
How to query data from one sheet to another?
I have a sheet which is essential reference data. I then have another sheet which will be used to actually do management with, but it needs to "pull" data from the reference sheet. VLOOKUP is only returning one data set. How do I use Smartsheet to query the reference sheet and return a list of rows which match a specific…
-
Carriage Return within a Cell - COUNTIF
I have read in other discussions that you can put in a carriage return to JOIN or COUNT through a work around by adding another column. I have tried this with a COUNTIF and I can't get it to work. My original formula had a comma between the results: ="Exceptional Performance = " + COUNTIF(Accessibility2:Accessibility6,…
-
Sheet summary formula to SUM a column where cells are formulas
In my sheet summary, I am trying to sum/total a column where the cell values are populated as a result of a formula. I can't seem to get a value. The formula for the cells I am trying to sum is this: =IF([Item Type]15 = "Stand Alone", "150", IF([Item Type]15 = "Unfolding", "450")) It is referring to one other column. I…
-
Can we create a report to find which sheets have proofs attached?
We have multiple project sheets and our team uses proofs within those sheets. I want to create a report to find out which sheets have proofs attached to them. Is it possible? If not report, is there any way using formulae that we can find out if the sheet has proof? For example, if the sheet has a proof attached, a…