-
Number of Days Ticket is Open
Hello all. I am a newbiw to Smartsheet, and I'm having trouble correctly adding a formula to one of my sheets. I have a repair sheet with a column that shows the date the ticket was created and a column that is labled number of days open. How can I have this column automatically display the number of days the ticket is…
-
How to display the grandparent task name or value in a cell
Hello, I would like to display the name or value in a cell, please. I could get the parent by: IF(ISNUMBER([Stages Tasks]6), PARENT([Stages Tasks]6), "") but I would like to get the Grandarent instead. Thx for your help.
-
Calendar vs Fiscal Year/Quarters settings
Hello, I was wondering if there's a way to update the calendar/gantt settings to use quarters based off of our fiscal year. Is that an option? Example - Q1 would be November-January Thanks, -PJ
-
Automatically update formula every month
Hi, I have a sheet listing expenses for every month this year, and expenses for every month last year (Jan 2015, Jan 2016, Feb 2015, Feb 2016 etc). There is also a column for Total YTD 2015, Total YTD 2016 (if today is December, it would add Jan-Nov 2015 in one column and Jan-Nov 2016 in a column next to it; for…
-
Template Description
I saved a sheet as a template and entered information about updates I made into the optional template description field. I cannot find the text I entered anywhere. Where does that information go?
-
IF/AND Functions
I am trying to create a sheet that will auto update a number in a cell using multiple IF AND statements. Is it possible to have multiple IF(AND statements in one cell or what is the format? When I have one statement it works properly, but I cannot figure out how to have it work with two or more. I am not worried about the…
-
Percent Complete by Cell Color
Is there a formula to determine percent complete of a task based on the cell color? Cells are filled with dates of various steps in a project and once those are completed, the cell is highlighted. I'd like to have the percent complete column update automatically when the cell color is changed. Help, please!
-
Roadmap Missing
The Product Roadmap seems to be missing. Is it being redesigned, or has it been removed permanently? We would often make suggestions to specific features listed in the roadmap, and I think having certain user input into pre-release features is a better way than releasing it all at once on the public. As I recall, a lot of…
-
Changing actual start date - Predecessors delete
Hi, I wonder if someone can assist me. I am running schedules for construction projects with predecessors (Finish-Start relationships) set up. If myself/or another employee change the actual start date of a line item then it deletes the predecessors. I know that to avoid that from happening - You must either change the…
-
If/Then Statement
What would be the best forumla to have one cell change status based on multiple other cells? For example, I have a sheet with four columns. I need a formula that won't change Fake Company 1 " Contract Closed to "yes" until all Lower Tier Vendor's associated with Fake Company1 have "yes" under Contract Closed.