-
Issues automating dashboard that feeds from a sheet with calculations
I am wondering if there is a solution or way around this issue in Smartsheet. I noticed that the reports function in Smartsheet does not allow you to do calculations such as countifs, sumifs, averageifs, etc. It only allows you to make graphs/metrics to report on if the information you are pulling from is number related.…
-
Effort Driven Tasks
This has been batted around for almost 5 years with SmartSheet promising that it will be upcoming. But I require Effort Driven Task. The Duration needs to adjust based on the % Allocation. This is essential. Please divulge why this has not yet been implemented and where it is on SmartSheet's roadmap for priorities…
-
need a function to set permission to one cell,or one column
need a function in smartsheet to set permission to one cell,or one column, it means, the viewers can view most of the datas in the sheet,but one or two cells,one or two columns,take the classified column within revenue for example, the datas inside of this classified column just can be viewed by owner and admins, the…
-
Report Builder: Adding Column in report that does not exist across multiple workspaces
We make use of multiple shared workspaces and users then create a report that shows them all line items that they have been "Assigned To". A user would like to be able then have a column available to her to enter her prioritization to work on the items. For example, she may want to use a number system 1A, 1B, 2A, etc. or…
-
COUNTIFS Formula
I'm having a hard time figuring out the formula to use if I have a column of dates and I want to count how many cells fall between a date range. I have tried the following formula and the results came back with 0, however I know there there are 7 cells in the column that fall under the date range. =COUNTIFS(Date2:Date73,…
-
Yellow rows.....
Can someone help me understand the why the yellow colored rows are showing up? And how to fix it? I think it has something to do with dates but cant seem to figure it out. See the attached screen shot. Thanks much.
-
RYG ball to change with expiration date
Hello I would like the ball to be red if the date is in the past, yellow if the date is within the next 30 days and green if it is set to expire in more than 30 days. Help? TIA
-
Unable to reach customer service or dedicated sales rep
Several members of my organization have reached out to our account managers many times since we purchased a package. Neither one has responded to emails nor voice messages. If these 2 individuals are no longer with the company, please provide new contact. It is imperative that someone respond back to us this week. Thanks!…
-
How Do I tell a cell that if the cell contains a date then subtract from another date, If the cell d
I'm stumped. I've written a formula that says, if my finish date is blank, then take my start date and subtract it from today's date to get the # of days open: =IF([Finish Date]2 = 0, TODAY() - [Start Date]2) Works great! But in the same formula, I'm trying to get it to say, but if the finish date is NOT blank then take…
-
Ability for cell linking to add new inserted rows
I created a sheet utilizing cell links in order to create all of my formulas needed for my dashboard. However, I noticed that the cell linked columns do not add the newly inserted rows from the master sheet. Is there a way for the cell linking to add the newly inserted rows from the master sheet or do I have to continually…