-
View only for majority of smartsheet and give edit rights on a few columns of data
I am trying to set up a smartsheet that different groups have update requirements on different columns. Thoughts on how to accomplish. I tried creating the main smartsheet providing those other "editors by column" to viewers, then created a report for a subset of the viewers with editor rights, but the report took the main…
-
Folders in attachments
I have a client who wants to use Smartsheet as a central repository for all data pertaining to a tech kit install. My Client requires folder hierarchy in attachments on a row. They require this to have better visibility of attached files on a row. Each row is to have a details of a piece of tech kit installed with a…
-
Field Labels in Card View
Hi - I'm experimenting with Card View and am wondering if there is a way to include the field name as a label on the Card. I have multiple numeric fields that I'd like to display on the card - number of teams affected, # of hours estimated, site priority. I know their positions on the card but others will not. Let me know…
-
Website form integration using API
I am attempting to use the API to add comments into a new row created by a form submission. I am currently adding new rows to sheets through forms on our website that integrate with (amung other things) the Smartsheet API. Our website utilizes C# so I am using the following code (partial) to submit to a sheet. Cell[]…
-
Automating RYG balls based on completed dates in parent row OR children rows
Hi all, I have a sheet with parent rows where the status column is updated with a RYG ball based on the completion date and due date of the row: =IF(ISBLANK([Due Date]108), "", IF(ISDATE([Completed Date]108), "Green", IF(TODAY() - [Due Date]108 > 0, "Red", IF(TODAY() - [Due Date]108 > -7, "Yellow")))) The children below…
-
Incorporate two data sets in one if/sum statement.
I have one column where I want to sum the total amount of days of work, however, I want the sum column to be dynamic based on the %Complete column if the percentage is <100%. I want the Sum column to show a total value anytime the % Complete is less than 100%.
-
Sights Dashboard Feedback from Power User
Hi there, not sure where to put in my feedback for Sights but I think it's a great tool but has the potential to really be so much more powerful for business users. I feel like I get stopped at ideas due to lack of features. Here are some ideas I hope you can add: - Export to PDF: we use the dashboard as sort of a…
-
Any way to change the "predecessor"'s values via the API?
I know that such functionality is not supported, but I was wondering if maybe there are work-around. I am creating an script that bulk edits various sheets by starting from one sheet (useful if you want to synchronize multiple sheets) - https://github.com/EffEPi/smartsheet_bulk_edit The problem that I am having is that…
-
Linking cells based on matching criteria
I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link…
-
Row & Update Requests - see message comment?
I have a sheet set up to track drafting requests. i.e. A staff member submits a request to create or update a site map. The persons in our drafting department get notified and one of them will start on the task. In trying to keep all communications within SS (and not email discussions), I've instructed the drafting…