-
Is there a limitation for current user selection in reports?
Hi, I have not found any info on this in the community or in the help sources. Before I start to implement reports and dashboards with the "current user" feature, I would like to know if there is a limit to the count off concurrent users accessing the same report at any time? Greetings Stefan
-
Dashboard Report Widget: Columns Content and GANTT aren't in the same line
Created a report and added the report via widget to the dashboard. Realized, that the lines are not matching....Content line height is obviously different to the GANTT line height. The report itself looks good and correct - the change is only when presenting in the widget. Is this a 'feature'? Thankful for any help
-
Countifs across multiple columns
Hi I want to count how many times Name=xx, has Green/Yellow/red balls across 7 columns =COUNTIFS({C-test Creation House applications Range 5}; [Column4]13; {C-test Creation House applications Range 6}; [Column5]12) (the range 5 is the reviewer column, and the range 6 are the 7 columns) It works if I only choose 1 column,…
-
Traffic Light Formula Based on Date and % Complete
Hello, I am trying to create a health status formula using the traffic light: Red, Yellow, Green Blue symbols. I would like the status to update based on the Deadline as well as the % Complete. The second set of conditions within the formula will not return a result. Here is the formula: =IF([% Complete]@row = 1, "Blue",…
-
Comparisons of dates(Committed date,New Committed date & Actual Completion Date)
Hello I have 3 dates column in smart sheet i.e Committed date,New Committed date & Actual Completion Date I need to compare these dates like if Commited date is> New committed date then i should get some color & the same way if committed date>actual completion date then i should get color & the same if New committed date…
-
Jumping to a very distant date
Hi everyone I have a Date column in a sheet, wherein I am unable to select / jump to a very old date (e.g. Jan 1, 1980) directly! Need help! Thanks
-
Dynamic push of data into Excel from a Report
Hey guys, I need some help as I 'm trying to automatically import some data from a specific colum displayed in a Report into an Excel spreadsheet and I don't really know how to do it... Here's the steps I've followed in order to have the data displayed dynamically in my Excel spreadsheet : #1 - I've created a report in…
-
Update health indicator formula for tasks that are not due to start
Hello, I'm relatively new to Smartsheet and found the following formula on this discussion board (I can't find original post). I need to update this formula to show "green" for tasks that are not scheduled to start yet, rather than blank. The columns in play are Planned Start Date, Planned End Date and % Complete If task…
-
Running Total in Pivot Table Smartsheet
Hey! I have a form linked to a sheet, and everytime someone replies to the form they are "raising a question". We have people working to solve these questions, and once this is done they change the status of this question to "answered" by checking a box in the sheet. I have the following columns: (1) Form submission date…
-
Incomplete Tasks Count Multiple Criteria
I am trying to account for the number of incomplete tasks for Symbol column types. For example, our 'On Target" column uses the RYG Balls, and i am trying to pull back the number of incomplete tasks based on their color (red, green or yellow). This is the formula i have tried to use based on recommendations from this post…
