-
Permissions on sheets using control center
Hey Everyone- I'm using control center to create sheets of tasks lists. I've got the project owner on several tasks and I created a report union-ing all of the tasks. (So far everything I'm describing is out of the box capability with SS CC). My project Owners want a report that show all of the tasks on their projects.…
-
Conditional Charts in the Dashboard
I would like to display a KPI if a condition is true ([boolean field] = true). Scenario: I have a helper sheet checking data entries for errors and a second helper sheet counting the errors. I would like to display a KPI on the dashboard showing the count of errors only if errors exist. The KPI then points to a report that…
-
Reports Error message- User is not assigned to this application
Hello, I published and shared my report, but am getting this error message . The publish Read only Full - Access Control screen shot is as under . What is the issue here and how can I get the user access to my report?
-
Why am I receiving this error: "calendar.smartsheet.com refused to connect"?
Hello, I am having an issue with embedding a Smartsheet Calendar to Sharepoint. I know it is possible because the exact thing has been done before on our team's Sharepoint. The individual who created the original Smartsheet calendar is no longer with the company. This caused a bunch of access issues leading me to create a…
-
Charts - Using first row as a target
Hello everyone, I am hoping someone could help me with a chart that I am trying to create. The chart shows number of hours by 4 categories per week, with the top row being last years average. I would like the chart to show last years average as a straight line across the chart along with the weekly values fluctuating.…
-
Help with a formula, I don't know what's wrong.
This discussion was created from comments split from: IF and IS BLANK to check dates.
-
Text String Question
Hello All, Quick question I just need this 4-6 digit number before - Retailer in this column but cannot get my formula to work since what I am pulling ranges from 4-6 digits. For example In my new column trying to create, I would just need 59552 from59552 -Martin Tractor or 178874 from 178874 - BROOKS TRACTOR INCORPORATED
-
Attaching Completed Form to Smartsheet row
Basically, my team wants a smartsheet and for that smartsheet, they want a form, but they don't want all of the info in the form to be filled out in the columns, they just want like the person who fills out the form's name. Then for the info filled in the form, they want it to just be automatically attached to the row. Is…
-
Is it possible to allow users to create custom alerts?
We are asking users to complete a form sharing meeting notes, recaps, updates etc. from association meetings/conferences they attend. The entries and any attachments are stored in a Smartsheet grid that we make visible to a broader company audience. We would like to give users from that broader audience the ability to…
-
Turn Off Email Notifications For Sheet Access Request
How do you turn off email notifications when someone is requesting access to sheets? I used to only receive email notifications for sheets that I am the owner of, but now I have been receiving emails for all sheets in Workspaces that I am a part of. I feel like this changed this week, and I'm not sure why.