Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2015 Posts
Archives for April 2015
Discussion List
Training Observation Form
I'm working with another department to create a trainer observation form in Smartsheet. The form is pretty long and has a lot of categories. When I started working with it the number of columns grew quite large. Does anyone have experience doing this in Smartsheet? Any tips? Thank you, A. Lopez
Update Requests Limited?
I am sending update requests for a sheet that has initial items filled in by formulas - dates, as well as "Yes/No" dropdown selections. This makes it easy for the person who starts with this template to put in suggested initial dates, then ask for exact dates from these directly involved. In the sheet the editor can…
today() function
I would like to conditionally format date columns based on whether something is past due of not. Can I automate that in smartsheets?
Fixing a milestone date
Hi, I am building a project that will culmniate in at examination on a specific date. This date is 24th March 2016 and everything else in the sheet builds to this date. How do I stop this mielstone changing date when I change the duration or dates of some of the precedends? Thanks
Contacts - name and company as ID
I am using Samrtsheet where I invite many participants to view or edit the sheets. Often I also have man y different users (contacts) that should be assigned to a task. The problem occurs when I have contacts with the same name e.g. John Johnson. It would be very beneficial to have a Company or another ID to deferenciate…
More suggestions/ideas
- A report that highlights broken links and cells with data in that doesn't conform to drop-down lists for the column. This would be really helpful for error checking in large scale set-ups. * * - The ability to format reports independently of their source sheets. * * - A few more system columns to help identify when…
Make Stars yellow by Default
I am creating a New Hire Checklist and one of the columns is called required. If that row's task is required the start will be checked and show up yellow. How do I make all the starrs in the required colum yellow by default? So we have to uncheck only what isn't required instead of vice versa.
Deleting User Accounts
We are struggling to come up with a usable process for removing access when a licensed user leaves the company. Especially when they own several sheets and workspaces. If I transfer the sheets using user management, they all need to go to an individual licensed user. If they are not shared on a workspace, those sheets are…
Need to Receive Out of Office Replies for Update Requests
I created a Smartsheet to collaborate with a department that is in another facility. The nature of our collaboration can be time-sensitive, and when someone is out of the office we need to know. The process that currently exists is to use email, so we get the automatic notification. However, when I tested this with a…
Removing columns from multiple reports
Good morning, Upon occasion we discover that a particular column in a sheet and subsequent reports is no longer needed and should be deleted. Is there a simple way to do so, other than having to go through every report to see if that column exists within? Blessings, Loann
