-
Use the End date and dependencies to drive the project timings
When a project and tasks are set up with dependencies and durations, the project manager should be able to drive all task dates based on the project end date, not just the start date. Often mid project the delivery date needs to be changed. With Smartsheet, a project manager needs to adjust the duration of all tasks…
-
Can't Get Conditional Formatting to Work
We're trying to identify new hires who are not producing to goal (see image (18) below to see the target ranges based on time in role). I have entered in what seems like conditional formatting that should work for 0-3 month new hires at their Month 0 mark (trying to turn red anyone below $30,000.00) but it's not working.…
-
Syntax error for nested IF statements
Hi there, I am looking to use a column formula to calculate review dates based on a few criteria. -If the 'Date of last review with no changes' is blank I want it to progress to the next IF statement: -If the 'Effective Date' is text I want it to return the 'Effective Date' -If the 'Effective Date is NOT text I want it to…
-
Cross-sheet COUNTIFS Formula Not Working as Intended
I am using a helper sheet to calculate projects that are Past Due, Due this Week, and Pending Review per Requestor Email (this email comes via a form). The formula I am having issues with is the the one I am trying to create to count the number of projects that are due this week. I need to formula to count the rows that…
-
NO MATCH error when a match exists
Hello - I'm stumped - I'm using a VLOOKUP to find values that I know for an absolute fact are in the first column of the reference table, but it still returns No Match. Is there something wrong with my formula? This is a screenshot of my formula in the sheet I'm trying to bring the info back to. The AAP ID-2 column is a…
-
Can I create a drop down list which will remove one choice after it is picked?
Hello - I have a form that I use drop down choices for delivery times at my place of business. I would like to upgrade to the business version but need to make sure this will work for me before proceeding. Currently multiple delivery time choices can be taken but I only want to show the times available. For instance, we…
-
Dark Mode?
I would like to suggest to the development team to add a "dark mode" for the users that are working away from offices or prefer the dark mode
-
I need a formula that will automatically move to the latest row with data.
I believe I have to use "Max Helper" but do not know the formula so it will automatically move down to the next row when the latest data is entered. The data in the latest row will automatically update in summary rows. Currently, I have to manually select which rows data I want in the summary selecting the "Max Helper".
-
Unable to copy or move rows to my destination sheet...
Help! My Destination sheet is a sheet of trouble tickets that is fed by a form. My second sheet is a list of preventative maintenance tasks. I want the maintenance tasks to copy/move to the destination sheet so that they will then become "active" but the Destination sheet will not accept any copy or move rows. I know that…
-
Smartsheet sending email to Track-it!
We use Track-it! for our helpdesk and looking to be able to send an email from Smartsheet to Track-it from a sheet. I've created an intake form for our sales reps to request information, ask a question, etc. Once the request is submitted, the sheet automation will assign people and then send the alert email. The email…
