-
DEPENDENCIES IN GANT CHART
How do I set up dependencies, working backwards from a mile stone / end goal.
-
Update Requests, reminders, notifications
I'm wondering if there is a way to set up automatic update requests, reminders, and notifications to be sent on a reoccurring basis until a task has been marked as complete? I see where I can choose to have these emails sent daily, weekly, and so forth. But I don't see where I can tell Smartsheet to stop sending these if…
-
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.
