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 2016 Posts
Archives for October 2016
Discussion List
Formula referencing cell in newly submitted row
Hi all, I fear this may be impossible, but it's always worth asking. I have a simple time logging sheet with a web form that just asks what project a user is working on. I have system columns use the time stamp from the web form to log the time. I am trying to use the difference between the submitted time and the last…
Calculate % complete based upon start and end dates?
Hello, does anyone know how to calcuate the % complete for a project based upon it start and end date? I have projects where my resources are "consulting" and I'd like to have a way to see the % complete of the project when I roll it up in a project overview dashboard. I tried using the traditional "yearfrac" formula…
Nested IF Formula - Date Error
Set up a basic Nested IF that does nothing more than display the mailer round status based upon a set of dates entered. With no dates inputted the formula displays the correct value, however once I input a date it returns "INVALID OPERATION". I've attached a copy of the formula below for commentary. Appreciate the help.…
Tracking of RYG Status changes
We have a fairly complex sheet that we use to track survey requests between us and one of our clients. One of the columns is a Status indicator using RYG balls. Both us and the client collaborate on the same sheet. We use it as follows: Green - Survey on track and continuing Yellow - Issues on the survey that must be…
How can I make a "Status" field change "Percentage Complete?"
Hello, I'm wondering how I can sync a dropdown menu (Status Column) to another column (Percentage Complete). Ideally, this function would change the Percentage Complete column to 100% when the status is marked "complete." Thanks in advance for your help with this! - Mike
Feature Request: Timesheets / Time Columns / Time Trending
What we want, is to be able to generate a daily or weekly report of how much time each person worked, and on which tasks. We need to be able to not only see the efficiency of the tasks, but also of the people. And if we can select a specific period of time, this would also be useful. I have a project where each row has a…
LOOKUP & MATCH together
Hi everyone, I use a VLOOKUP and MATCH function in Excel to find the intersection of vertical and horizontal values (intersection of a matrix / table). I can't seem to get this working in Smartsheet and need some help. For example if I have Likelyhood = Likely and Impact = Moderate then I want the Criticality to return the…
Editing Templates
When you select a template it only gives you the option to "Use Template" or "Cancel" Is it possible to edited a template that has already been created? Thanks in advance for your help!
Cannot open published calendar in Outlook
I am trying to publish and open a calendar in Outlook but receiving an error. I have tried clicking the link to the calendar directly in SmartSheet (Go to Calendar View on the left menu, then select Publish at the bottom, enable publishing and Get Link). And I have tried going into Outlook and adding ti manually via File,…
Due Date is Past Due - Checkbox
I'm trying to write a formula that will "check" the checkbox if the Adj End Date is Past Due and the % complete is not 100%) I started with just the Adj End Date portion and have not added the percent complete to the formula. This isn't working... =(IF(TODAY() > [Adj End Date]5,TRUE,FALSE) I then want to do conditional…
