-
Dashboard - Variable Applied to all reports, graphs etc
Hi I have a requirement to report on the current data for a period and using a Dashboard makes a lot of sense except that since I have to analyse the data every week I need to redo the report each time I want to change It would be great if I could create a variable (1 or more) that can be applied to the incoming smartsheet…
-
SharePoint/Smartsheet Integration
I have a list of data that's maintained in a SharePoint Online site. On a weekly basis, the list info is downloaded and then uploaded into Smartsheet, where that information is used in several reports and Dashboards, Is there some additional functionality or extension capability where this process could be automated?…
-
Have a different email UI than what's in the request an update form
Hello - I am sending out pretty lengthly update request logic emails. I was wondering if there was a way that when the person receives an email they see only a few columns, but when they click the link to update the form, all of the columns appear. For example - I'm sending out an update request with about 24 columns. So…
-
Using Smart Sheet and Web Form to manage testing
Hi, Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering) across multiple users performing same test case? I'm currently using a reporting template but there are numerous…
-
Dynamic View
Is there a way to use the @name feature in the comments section of dynamic view? This is a great feature in the sheets but doesn't work for whatever reason in the dynamic view.
-
Dashboard Reports & Row Attachments
Hi! I was wondering if there might be a way to display the "attachments" or "comments" column of a report via the report widget when working on a dashboard? Essentially, I would love to be able to see if/when a row has either a comment or attachment linked to it via the dashboard. It would be even more amazing if that…
-
referencing using @row
I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question. I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this: =IF(DidIncidentOccur@row = "Yes", 0, IF(YEARDAY(Date1) > YEARDAY(Date2), DaysSince2 +…
-
Creating a form with Multiple Logics
I have a very large worksheet - almost 80 columns wide. Of those, about 20 are formula "Only" columns where personnel will not enter data. I would love to use the same form, select from the drop down and the fields auto-populate. But I am getting this error. Is there a limit? Or is the error because I am selecting the same…