-
Embedding Dashboard in SharePoint 365 (Using Chrome)
Any idea why an embedded Dashboard would not work in Chrome, but does work in FireFox? In Chrome I can embed a sheet onto my SharePoint 365 site with no issues. When I embed the dashboard I get the following error: I came across a post stating that it works in FireFox, tried it out and what do you know? My company's…
-
Send A Daily reminder based on Status field
First off thanks for this great community. Being new to Smartsheet, this has been a great resource to help with the deep dive. I would like to report so far so good!! I have been digging and looking into the process to send a daily email to update staff on what is left on a task list with a status not = completed. The…
-
Dashboards - lock widgets into place
I am building out a dashboard and have widgets in place, but when I add a new one, and move it to the area I want above or between existing widgets, the widgets move and it is challenging to get them back to where I would like them. Is there away to lock widgets so they don't move and then unlock them when needed?
-
Can you create a folder on an admin level?
We use Smartsheet for many different projects. Since 2018 we have accumulated many sheets. These sheets are shared with many users, in different departments. Is there a way to organize these sheets on an admin level, for example by construction year, without having to set up the same folders on a user level, over and over…
-
Question on Dashboards
I am trying to create a graph on my dashboard that shows a month by month historical trend line graph. When I try and graph out the info it sorts the months by alphabetical order rather than in the correct order. I have 2 columns on my source sheet pulled into a report one that shows the date an item was entered and I have…
-
Is there a webinar or video tutorial on how to set up the Project Management Office template?
I seem to get stuck whenever I try to add an additional project and the formulas between sheets don't seem to transfer properly. I've reviewed the written instructions several times but I can't figure out what I'm doing wrong. I would love to see an example of how to set up multiple sheets that roll up to the dashboard.…
-
need creative idea: work document (sheet/report?) shared with external stakeholder, frequ. comments
Hi, I´m hoping that someone has a creative idea for me. Scenario: While working on multiple projects, I depend on frequent updates from an external stakeholder (ES). I thought I could set up a report and share it with the ES so that we can both use the comment feature to exchange updates/feedback, but sharing a report…
-
Drop-down choice based on rows in another sheet
Is it possible to define the single choice column, for which possible choices are loaded from another sheet? For example, I created a nomenclature sheet for issue types. I use it to define (via VLOOKUP) a issue code prefix based on selected type. But the choice of types itself I have to type in the consumer sheet. So, when…
-
Using forms to add data to an existing row
Hello, I can see that a form will populate data into the next available row in Smartsheet. Can forms be used by other Team members to to gather and add info to pre-existing rows, governed by a specific date as an example? Regards, Richie
-
Add month to Date
Hello, Please help me why when the "C Date" is December, and the "IN Freq" value is "12 Month" I got an error "#INVALID VALUE" and it works if "C Date" is December and the "IN Freq" value is " 6 Month" with the formula below: =IF([C Date]@row = "", "", IF([IN Freq]@row = "", "", IF((MONTH([C Date]@row) + VALUE(LEFT([IN…