-
Dashboards | I can see lines in a report of a sheet not shared with me
Hi Using Dashboards, I can see lines in a report from a source sheet that's not shared with me. When I look in the report (and not the dashboard), I cannot see those lines. I assume this is a bug? Michael
-
Dynamic Charts
Is there a way how the charts in a dashboard can be updated automatically as one add new rows to a database? Thank you.
-
Dashboard
Hi, I want to report on the number of form submissions in a dashboard - can anyone tell me if this is possible? Many Thanks
-
Using TODAY() as a date range
Hi All, I was hoping to be able to use the TODAY() function as part of a date range check using the IF and AND functions then using column name >= TODAY, column name <= TODAY() in a nested IF statment. =IF(Complete1 = 1, "Up", IF(Start1 = TODAY(), "Angle Up", IF(AND(Start1 >= TODAY(), Finish1 <= TODAY()), "Sideways",…
-
Release Milestones
I'd like to establish a row that holds our release schedule. Every three weeks I'd like some visual marker that indicates that we've got a new release. That seems possible in Smartsheets, but establishing a cadence of milestones seems to require individual rows for each release. Is there a way to place markers without…
-
Average the number of days
I am trying to work out the average number of days quotes are being taken to be submitted. The columns i am working with are Enquiry Date and Date Quote Submitted. I have done a Sum formula to count the number of days taken (=SUM[Date Quote Submitted]1 - Enquiry Date]1 but because not every enquiry has a date submitted…
-
VLookup reference another sheet
Hi I am trying to do vlookups that reference another sheet. The main sheet has 13,000 cells, but when I create the link, it says its been denied as the limit is 25,000. I should still have 12,000 cells free. Does anyone know what is happening here? Thank you
-
Indent Greyed Out
Hello, I am unable to use the indent feature. I followed all of the instructions in the tutorials as well as looked up in the community other issues and followed those instructions but the indent option is still greyed out.
-
Remove User from Enterprise Level
Good morning, In the Team level, I had access to a report that showed me all Users per sheet/report, so that when someone left/changed departments, I could easily see what access they had. This report is no longer available to me since we went to the Enterprise level, and our SysAdmin says that the report only shows them…
-
Project Team Widget
I want to make a dashboard widget for my project that shows a report containing all individuals that were assigned a task in said project. I know that the "assigned to" column can be pulled in a report, however it shows multiple instances of each person because each person does multiple tasks in each project. Is there…