-
Help with Column Edit Permissions
Hi All, When I share a sheet with my associate (or visa versa), the person who did not create the sheet is not able to edit the column properties. They are 'grayed' out. I checked and it looks like we both have the same permissions, so Im not sure why that happens. Any advice would be appreciated! Thanks, Robyn
-
Help with date formula
Need formula to calculate a date: Spreadsheet has (3) Columns as follows: Cal Type (drop down) with 2 options - In-house or Third-Party Next Cal Date: Date Reminder Date: Date Would like formula to calculate the following If/then scenario: If value in Cal Type is "Third Party" then need Reminder Date to be Next Cal Date -…
-
Change font size when printing a sheet
I see posts from 2015 but no recent postings concerning changing the font size when printing a sheet. Is there a way to change the font size when printing? Depending upon the type of sheet and number of columns, the font is too small for the majority of readers to read comfortably.
-
Sight attach file widget - link to attachment in a sheet
I have several sheets used for tracking projects, and typically there are a few very important documents which need easy acces, versus the list of many other attachments. I'd like have a quick way inside the Sights feature to link to a specific row/cell in a sheet that has an attachment. So from the Sight, while viewing…
-
Completing a Job Summary from within SS
My Manager uses Smartsheet to provide job information to the crews where I work. When the job is complete, the job's Lead uses the information from smartsheets to fill out a Job Summary sheet. The Job Summary sheet is currently on paper but we also use an Excel spreadsheet and print or email this. Is there a better way to…
-
Trying to connect a check box column to a completion date column
I am looking to connect a column in which I have a check box indicating done (check) and not done (unchecked). On the same sheet I have a column for Completion Date. I would like the sheet to auto-populate the Completion Date field each time a check box is checked as done. Is that possible?
-
Hide or reveal a web form question based on answer from previous field
Is there a way to hide or reveal a question/text input field in a web form based on the answer from the previous question? For example, I am creating daily truck check forms for our paramedics and one question is "how many back rafts are there?". The dropdown list choices for them are "3", "Restocked", "Ordered" and…
-
Resource utilization across projects
Is there a way to see the TASKS a resource is assigned to, across projects? The Resource View only shows which projects and overall Allocation %, I want to see the specific tasks. Thanks!
-
Opening a link to a sheet (Smartsheet), while utilizing the Smartsheet App
I have employees that exclusively operate within the Smartsheet App (iPhone & iPad). The sheets that we are working with, contain hyperlinks to other sheets. Upon opening the link to another sheet, while in the app, it redirects the employee to the web version of Smartsheet...it does not open the link in the app. I am…
-
Zapier and Service M8 integration with Smarthseet
Hi, I was wondering if anyone has any info on how to achieve what i am trying to do: I have field management software that I use called Service M8 - it works with Zapier to update and or create rows in Smartsheet. We use Zapier to make a new row in Smartsheet and the trigger is when we make a new client in Service M8. That…