-
Can a Dependency outcome be set to show an early or late value in production process?
Hi There, I am using my smartsheet to manage a production of furniture goods. I have set columns up for Start/ Finish/ Expected finish/ Duration/ and Delay to Expected finish. This will enable me to see where the delays are happening in the process and analyse where to improve. I have set the dependency between the…
-
Subcontractor needs Help
We are new to smartsheet and looking for advice on the best templates to use to track schedules, and being able to track delays, etc. Would anyone be willing to share ideas or sheets that you have found useful to your business? Thank you! Sarah Link
-
Sheet Summary Limit
Is there a hard limit to the number of fields we can add into the new Sheet Summary page?
-
SumIf with Date Range
I created a project management financial sheet (client / projects / deliverables & invoicing). I am trying to sum the value of invoices between a date range (screen grab). This is what I thought would work: =SUMIF(DTI:DTI, AND(@cell >= DATE(2019, 10, 1), @cell <= DATE(2019, 10, 31), InVAT:InVAT)) and it returns "0"? The…
-
Automatically Check a Box upon entering a date
In my Smartsheet sheet, I'd like to enter a date in a column and it would automatically check a box in another column. FYI - I have a surveyor in the field entering a date of his survey and I have a Manager who just needs to know the survey took place, but doesn't want the date. Any advice is appreciated. Thanks,
-
IF AND Function For Reporting
Hi guys, I am trying setting up a new report for my team which will allow them to bring through project activities based on the following criteria: * The week the activity happened in is before today's current week. * The RYG status is red OR green OR yellow I am using a column set up as a checkbox and trying to put an IF(…
-
Designating who gets a back up email
Is there a way to change who gets notified of a recurring back up? Right now it states the workspace owner will get notified. Is there a way to designate who gets the email other than the workspace owner? Thanks, Paul.
-
Need to calculate an Expiration date
I have a sheet that I have included the current inspection date. I need to calculate two expiration dates. One column @ 90 days post the inspection date and one column @ 365 days post the inspection date. Any help would be greatly appreciated. Thank you, Nicole
-
Move Rows
Good morning! Searched around and don't see an answer to this. When moving a row from one sheet to another do all the same columns need to exist on each sheet, or will the move option simply populate the columns that do match between the two sheets? I think I recall that both sheets have to have all of the same columns but…
-
Automatically Adding Rows Based on Change in Another Sheet
I would like to be able to automatically populate rows in a sheet based on the change in status in another sheet. For example, if I have a spreadsheet of jobs I'm bidding on that has a column with dropdown options of "Bidding", "Won", and "Lost", I would like to have a sheet that auto-populates a row in a different sheet…