Rookie Help with Due Date and Overdue
I have a start date column, due date column, completed date and would like to have overdue flag column. How to set formula that if due date passes, no completed date and have flag come up in overdue column?
Help with SUMIF
Hi I am calculating time spent on work by Job Number and by Date I have set up a SUMIF formula to add time spent by job number: =SUMIF([Job Nº]:[Job Nº], "64501", Time:Time) - Works fine. the formula to add time spent by date is: =SUMIF([Job Date]:[Job Date], "30/03/17", Time:Time) - and the calculation comes out as "0"…
Freezing rows & minimize/maximize feature in sights
Dear smartsheet team, the freezing of rows would be more than helpful! I am working with Smartsheet on various customer projects and a have a great demand for this feature! Is there a status on how this goes? I think its a frequently asked question... Also regarding smartsheet sights, it would be great to add a feature…
If you have favourite formulas that you will use on multiple sheets can they be stored as template formulas or do you have to copy from a sheet each time you want to use the formula?
Simple Performance Review Template?
Hi, Anyone that can help? I found the themplate: 'Simple Performance Review Template' on this Smartsheet website: https://www.smartsheet.com/free-employee-performance-review-templates But I can't find the template in the Human Resource category within Smartsheet. Any suggestions? :-) Kristian
Formula to change date based on adjacent drop down menu
I'm trying to set up a tool inventory, to help keep track of the location of all our big ticket items. I've created a row for each tool. Asides from various descriptive colums, I have one column set as a drop down list (listing the numerous job sites the tool might be pulled to). I also have a Date Pulled column, to show…
Workbook template set for new project
Hi there, My first post to this forum and somewhat new user to Smartsheet. Can anyone advise if below is possible and if yes, how to do this or point me to help on this topic. Thanks a million! *** I want to create a template set for a suite of document that I need to create for every project. What I do today is use an…
ABSOLUTELY IMPERATIVE - DEFAULTS FOR FIELDS
This is a MAJOR fail - that while you can set a field to a default value in the form, you can't do it in the sheet itself - !!!!! this is a FAIL! This should be addressed as soon as possible by your team.
Hi - I'm trying to figure out a formula that will pull in the next milestone date into a report or sheet. I want to include the project name, the milestone name, and the milestone date. I don't want to see all of the milestones, just the next one that is scheduled.
It's going on 14 days and I still have no idea how to access the Solutions PM templates discussed in this webinar: https://www.youtube.com/watch?v=fGdbyfiYFZo Customer Support has been no help what so ever. Can anyone provide LINKS to the templates, because Othello Barbosa e Silva | Smartsheet Sales Development…