-
Working Days Counter Based on State, Lock # when completed
I am trying to create a counter that counts the number of days in work of a task, the counter only counts the days in work when the Scrum state of the task changes to sprint . I want the counter to stop counting when the state changes to done and lock that number of days in work (days in work from sprint to done) and still…
-
April 15th Smartsheet Service Event
Last weekend, we performed a datacenter fail-over exercise to validate our disaster recovery capabilities. As a result, today (Monday April 15th), some of our customers experienced application performance issues related to the core application, reporting, collaboration features, and workflow rules. Three of these issues…
-
Report Builder not working
Is anyone else having trouble with their reports not working properly today? I can't get my report builder to recognize all the criteria I've selected. It is updating with incomplete criteria... when I change the criteria but it's just ignoring some conditions and not others. For example: column name "Status" = "closed"…
-
Report in Publish View - no sorting abilities
I am trying to share a report via published view and noticed that people with that link cannot sort rows. The option is there but it is greyed out. Is there something just not turned on to be able to do this?
-
Linked Cells with Numeric Value not working in Chart Widget
Hi, I have a roll up of numbers for the total of checkboxes checked off in our main data sheet. I've linked that totaled value into a separate sheet via the link cell capability. That is somehow not getting charted, and is showing up as "Invalid data"? What am I doing wrong?
-
VLOOKUP is data type of TEXT instead of DATE - sorting is off
I am currently creating an report which looks up dates based on specific milestone tasks over a number of project sheets. When the vlookup calculation is entered and I hit the Return key, is it giving me an alert that the value is not in date format. Being the admin, I am able to override this. But when sorting, it sorts…
-
Reports break when changing a column name on sheet?
I have several reports set up and found recently that if I need to change a column name, the reports don't automatically see that I changed the column name and are now blank because they're looking for the old column name. It seems like this must be currently by design, so I'd like to request that Reports use column IDs…
-
Error in Smartsheet export?
Since this morning I get an error message when I want to download the login history. See screenshot below. Is that only me, or do other people have the same problem? Thanks
-
Search Projects as Per RYG status
Hi, I looking for solution or moreover a formula to get a project name back as per RYG status. But i am getting problem, i have a same RYG for more then one projects. For example: i want a list of projects As RYG "RED", the selection has to show me 2 projects in retuen Project 1 Red Project 2 Green Project 3 Yellow Project…
-
Bulk Report Update
Has anyone come across a way to update the criterial for multiple reports at once? We have several reports that all draw from the same set of sheets. Every time we start a new project (and thus create a new sheet), we have to go to each report and attach the new sheet. This is tedious and time consuming. I've even tried to…