-
Point Automations to Alternate Smartsheets
I like using daily summary automations rows added or tasks marked complete, but the source file where this is tracked can be confusing. I'm looking for a way to run the automation from the source sheet, but have the email include a link to a report, dashboard, or alternate Smartsheet. I could paste the URL in the message,…
-
Dashboards on mobile devices (tablets, phones) have poor performance.
There were issues with dashboard performance being reported last week (July 7th) and the Smartsheets dev team posted that they fixed it the same day but I am having severe performance issues on mobile devices still. The dashboards on our desktops are slightly slower than they were before but not disruptive. However, the…
-
Calendar linked to outlook
Hi, I have created a calendar and have linked it to outlook. But for some reason I see only the start date in Outlook and not the end date. A 2 days appointment is showing up only on the first day. In Smartsheet and in the calendar app it showing up correctly. Thanks Christine
-
Is there a way to only have one attachment visible on reports?
I am wanting to make a report of certain project details/agreements for another department, however I am only wanting them to have access to the fully executed agreement (one document/attachment) and not all of the supporting/additional documents that are attached. Any ideas are greatly appreciated!
-
Filter Incomplete tasks that must start or finish between a certain date
I am trying to create a filter that provides a list of tasks that are scheduled to start and finish between a certain date but are not 100% complete. I have been able to implement the first part with a filter where rows matching at least one condition, is: Start between X and Y or Finish between X and Y. I would like to…
-
Is there a way to set the font size in sheets with forms?
Hi SS Community. Is there a way to set the font size of incoming form responses? Right now responses come in at font size 10 and I have to manually adjust down each time. Is there a property or setting to adjust this for all responses? Thank you!
-
Is there a way to create a form that utilizes a drop down and brings in info entered?
We are looking to create a form where we have 3 stages of lab testing that are done on a bin. I would like to create a form where stage 1 can enter basic data for that bin and the testing completed in stage 1, then have our 2nd lab person go to the form, select the bin number and the data from stage 1 testing would…
-
Harvey Ball Formula Question
Where di I make a mistake? Current formula is below and not correctly converting Stage Progress to a three quarter Harvey ball when Last Activity Type is Final Presentation. =IF([Last Activity Type]@row = ISBLANK([Last Activity Type]@row), "Empty", IF([Last Activity Type]@row = "Initial Presentation", "Quarter", IF([Last…
-
Smartsheet Forms
Hi Team, I have created a Smartsheet form basically a survey, is there a way to capture who all have sent the survey to whom? we are using the email feature while sending the survey, as of now it only captures the filled responses, I want to find out , how many surveys have we sent and how many have responded.
-
Widgets forget chart type and columns included when data source is changed.
I have a dashboard with several widgets that are fed by one smartsheet. I update the smartsheet every friday with that week's collected info. I then go into the dashboard and change the data source for the widgets to include the new line with the new weeks info and usually to maintain a 4 or 5 week rolling selection of…