Updating projects when parent & child rows are involved
Hi, I have built a large projects register for my organisation which uses parent rows to express the Project Name, and children rows for each Stage of that project. So for example Row 1 would be "Park Upgrade". Row 2 would be "Initiation/Planning". Row 3 would be "Design/Development" etc. Also on the each children row, I…
Smartsheet cloud environment and FedRAMP
Is the Smartsheet environment FedRAMP certified?
Alert when a row has not been updated in the last 14 days
A project lead has requested an alert that sends to him when a row (assigned to a project manager) has not been updated in the last 14 days. My attemtps at a solution: 1: Include the system column (Modified - Date) 2: Trying to apply conditional formatting to make it easily visible when viewing 3: Can't seem to work out…
Does anyone know if there is a way to track an employee by GPS who is on the road that will populate into Smatsheets?
I made a directory listing all of our smartsheets with a brief discription of the sheet. I made the name of the SS a hyperlink that takes you to that SS. I then shared the directory with my office. My problem is if there is a sheet someone in my office wants to access but the sheet has not been shared with them then I want…
report to create form letter
Has anyone used the report function to create a form letter. The report would pull static data from one sheet and dynamic entered by a web form from another sheet. Thoughts?
Printing of Web Forms
Hello, The Maryland State Department of Education would like to transition the Notice of Grant Award process from manual entry to collecting requests via a Smartsheets web form. A requirement of this process would be to recieve signature and initialed approvals on a paper printout of the form after it has past through each…
Publishing a Calendar to Google
I have published calendars to google several times by going to calendar mode in SS and selecting the "Publish to Google Calendar" button then selecting "ON" and it shows up on Google under "My Calendars" . But my problem is that one employee is trying to publish a calendar to Google but it will not show up as one of their…
I would like to be able to show data graphically (ex. voters checking in during election day). What I have done is export to excel to create the graphs. Is there any way to do this in Smartsheet?