-
Card view for reports
Hi All- I really love the card view but can't figure out how to see my reports in card view. I understand that there has to be at least one drop down menu for card view to be an option but it doesn't look like we have the option make any of the columns in a report with drop down menus. Is that correct? Is card view not…
-
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,…