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 2017 Posts
Archives for December 2017
Discussion List
Range selection
Hello, I am wondering how to choose a range on Smartsheet that will go on forever? Please advise.
Automatic Quarterly Reminders?
Hi there! I am building a database to monitor multiple cashflows and am tying to figure out the best way to set up an automatic reminder for the person responsible for each cashflow to update financial information on a quarterly basis. I was thinking of creating reminder date columns (and hiding them) for each quarter. Is…
Conditional Formatting Not Working
These conditional formatting rules are not being applied to my sheet for applicable rows. Does anyone have suggestions?
Round down fomula
I would like to round down the figure into thousand. However, it seems there is only a Round function but to Round down. How can I make it happen? Thanks
Fleet maintenance template
Hi there I am looking for a template to adapt to assist us with machinery maintenance on the farm. I want to be able to record work done and to set reminders for upcoming maintenance tasks. I am sure someone must have already done something similar with smart sheet - any help gladly received. Andrew
How do I link a project worksheet into the row of a separate worksheet?
Hi, I'm new to Smartsheet and hoping to find a solution to the following: How do you link a worksheet to a row of another worksheet? For example, I have a worksheet for my Master Project List that lists about 70 projects. Each project has a separate worksheet for its individual project tasks/deliverables. I am hoping there…
TSheets Integration
Is there a capability or a hack to integrate TSheets reporting/data with Smartsheet?
Moving attachments and comments to a new sheet
I have since decided to combine multiple sheets into one master sheet (I was beginning to duplicate data and tried to put a band-aid on it with cell linking). I did a Save As New..from the most complete sheet of all of them. The problem is, I have a bunch of attachments and comments on a few different sheets that I want to…
Can a Date autoupdate to the current date
Is there a way to set a date to dynamically update to TODAY? For example, I have a sheet with start date finish date and duration. I want to track how many days into the project without having to update the finish date continually.
Project Health Based on task completion vs project completion
I am trying to determine a way to communicate/graphically represent project progress based on today's date in relation to the start date and projected end date of a project. So if we have a 90 day project and we are on day 50 I want to see Project Progress of 55% I already have a data point for Task Completion percentage…