-
Cell linking
Hi, I was wondering if it is possible to link my sheet to another sheet that will automatically generate new entries. I have a master log in Smartsheet that i use for all the background check information that only an internal team has access too. When i filter though for a certain company in that sheet I would like to be…
-
Does 365 / One Drive help the attachment process within Smartsheet?
Hi, Our Company has just installed Office 365 to all laptops. We did this for various reason: 1. We didn't want anyone saving work to their C drive and losing it if a virus struck (so everything that isn't saved to Smartsheet is saved to One Drive. 2. We wanted to ensure that all documents can be accessed from any laptop/…
-
How do I automate and validate data from one column to another
For example, have a list of cost centres in one column using a drop down list, now I want the managers name for that cost centre to populate in next column. In excel i would just use a lookup or match/index to validate and populate. Cannot work out how to do it in smartsheet.
-
Date/time stamp format on PDF export
Hi is it possible to/how can I change the format of the date/time stamp included when export to PDF? I'm not sure where it is coming from, but it would be very nice to drop the "o'clock WEST' wording that is being included by default (see attached screen shot). I am using Safari v9.1.1 on Mac OS 10.11.5 Thank you Erik
-
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%.
