-
When will timeline view be available on dashboards? Struggling with dashboard
Hello, I am struggling with representing our project timeline on our team dashboard in a summarized, visual way. If I include a report with a Gantt chart on the dashboard, the Gantt chart task labels appear very small, and overall it is not visually impactful. I noticed Smartsheet recently came out with a Timeline view,…
-
Automation Assistance
Good morning Community! I have created a sheet to keep track of all company board meetings. Each department is responsible for submitting material (attachments) prior to the meeting and automations are to be put in place to remind board members of the deadline to submit. The issue I'm having is, how can I have each…
-
Masking certain columns to viewers
Hi all, We have a main spreadsheet where we keep all of our projects including the budget for those projects. I would love an option where I can either share that spreadsheet, but mask certain columns or duplicate that spreadsheet, but not fill in the budget columns and then share that spreadsheet. Is there any option like…
-
Locating Form Submissions
The form is active as colleagues have told us they have submitted, but we have no idea where to find the results. The form owner is no longer available. How do we locate the results?
-
Conditionally Copy "Modified By" value to another row cell
An update to a column called, "FOO", should trigger an event where the contents of "Modified By" are copied to a column called, "BAR". Steps. 1. I change the contents for "FOO" from 'a' to 'b'. 2. "Modified By' changes to my email (the usual automated way) 3. My email is copied over to "BAR" **If a field other than "FOO"…
-
Collections not available to enterprise user on multi year contract
Hello, Our organization is on a Enterprise multi-year contract that is not on the "new user licensing model". I am an EAP user and have lost access to Collections and File Library and I understand we will not receive any of the new updates unless we switch to the new user licensing plan. What is Smartsheet doing to provide…
-
"You do not have sufficient permissions on this sheet to make this change."
Hey all, Been working with Smartsheet for years and never run into this. I was shared as an admin (I quadruple checked I am 100% an admin on both) to two sheets earlier today and am attempting to cross reference one for a fairly complex formula. Every time I try I receive this message. I logged out, had the other party…
-
Graph not displaying correctly
Why is my graph displaying like this? My In progress calculation is 39%, but the graph is displaying 93%. Below is my metric sheet.
-
Question on graphing data on a dashboard while using a smartsheet form
Hello, I am trying to graph data for production as close to real time as possible. We run a test and then use a form to populate a smartsheet. I have a dashboard pulling from that smartsheet to graph the data. I want the graph to populate based on new data entries, however the graph will only populate based on the data I…
-
Unable to import an Excel or .csv file into Smartsheet
Hello, I have a file which was exported from a sql server and converted to an .xlsx file. The file only has one tab and contains 12K records. I am unable to import the file into an existing workspace in Smartsheet; upon first attempt, I can select the file, then select the primary column, but then the Smartsheet 'import'…
