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 May 2017
Discussion List
create form from text file or spreadsheet
Full disclosure, I just initiated a trial of Smartsheets and haven't yet taken the time to learn its features; this might be as easy as copy paste. Is there a way to create a form from a text file or spreadsheet list? I have a long list of items I want to track during user tests, and thought a form might be a good way to…
adding conditions to recurring reminder formula
I'm trying to expand on this formula that triggers a recurring reminder (explained here: https://www.smartsheet.com/blog/support-tip-recurring-reminders): =IF([Flag1]1 = 1, TODAY(), "") I want the return value to equal today if the flag is checked and another date cell is in the past. I tried a bunch of variations and made…
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 -…
Resource time allocation
Hi, I am new to Smartsheet (have used MS Project) I am looking how the following would be best to implement. An overall task may take say 15d's out of that 15d's an assigned resource may only be required for 1 day out of those 15d's. Thanks for your help in advance. Cap
Control and/or Burndown Charts
I have not been able to find information on how to create a control and/or burndown chart in Smartsheet to track the cycle time of tasks as they pass through different statuses and the remaining work. I was planning to add columns and create formulas to track the dates when the status changes and then create reports to…
Due date PRIOR to weekend or holiday
I have a one date upon which all other due dates are calculated. We have holidays set up for the account. I need the due dates to fall on the weekday PRIOR to the due date if it is a weekend or holiday. It appears the Workday and Networkday functions fall on the following week day, which doesn't work for me. This formula…
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.
View today, including one day and multi-day items on sheet
We track all our promos on one sheet. Some of them run one day, some of them run for several days, some of them run more or less permanently. I need a view of everything running on a given day. The filters do not appear to permit this. Any ideas? Ideally, would like this to run in calendar and gantt views. Alternately, is…
View Event/Project Overlap
We have 5 events throughout the year that each have their own sheets. These events run: December to February January to March March to May April to June August to November. Is there a way to see what parts are over lapping? Ideallly we do not want all the information in an additional sheet. But we're looking for maybe a…
New version of the object
Dear Colleagues, I have come across the error message reading that the newer version of the process already exists when I am editing my workflow. Could you please advise how to avoid such error?