-
Reference Predecessor Cell / INDIRECT Function
I'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My problem is that I'd like to adjust the formula so that it references a predecessor task (as…
-
How to compare a date range using a cross sheet reference
Thanks, AJ
-
Integrate Master Schedule
Hi all - We are really struggling with Smartsheet's project schedule capabilities. We were originally led down the path by the Smartsheet employee aligned to our implementation hours to create one sheet (which is now 5K lines and growing). We cannot see bunching of activities, overlapping activities within a timeline,…
-
What to do when I can't view/see or see the Shared Filter options while other Users can?
I can't view/see or see the Shared Filter options that a sheet collaborator with Business account created but other collaborators with Free User account can see and use the Shared Filters. What is causing this? I have a Free User account and I have tried signing in and out and refreshing the page to no avail. What should I…
-
Dependency Logic based on one or the other predecessor tasks
Is is possible to create schedule logic where a dependent task is dependent on one of two predecessors (either or not both)? For Example: I am trying to build out a schedule template for if a permit is required vs not for a specific project. IF a permit is required then the rest of the schedule should be based on the…
-
Rows will not stay in place. NEED HELP NOW
We use a sheet as both a schedule and data collection tool as part of a much larger system we just put in place (literally 5 days ago, moved from google sheets). The information is organized manually first by employee and second by the priority of projects. Recently, the information in the sheet began jumping randomly…
-
Ability for PM's to select which projects they want to receive a status update request e-mail
On an ad-hoc basis I need project managers to be able to select which project(s) they want to receive the status update request so they can update accordingly. Currently In my dashboard I give them access to a separate "project selection" sheet containing the project list (linked in from the master data sheet) and a…
-
Issues with alerts - not sending 'right away'
I created alerts to be sent 'right away'. However, we are receiving them via email several hours later - sometimes 12 hours later. I confirmed that I checked 'email' in my notification settings. Can you please help me figure out why there is a delay?
-
Calculate Reverse Date Format
Hi dears if someone can help with this format I have 3 cells: 1-ESTIMATED REQUIRED DELIVERY DATE: include the estimated date of delivery 2-PROCUREMENT TIMELINE: autogenerated including the number of working days 3-PR ESTIMATED SUBMISSION DATE: I need to create a formula that can automatically calculate the reverse date of…
-
Percent Formatting applied, but entry of 100 is shown as 10,000%
I have the entire column formatted as a percent, but when I enter 100, it shows as 10,000%, or when I enter 1 it shows 100%. Would like for the number entered to show that percent.