-
Stop Predecessors from being deleted when a date is deleted
Sometimes we need to just delete the dates to start fresh or copy rows to use for another project, but deleting the dates also deletes the predecessors. I was trying to test a schedule template with many hours of work on defining the predecessors. When I wanted to blank out the dates again so it could be used as a blank…
-
Net Days between a previous day and today.
I have the following columns Comments Date of Last Attendance Weeks Not Submitted Under "Comments", you might see something like "Last Attendance Day: 11/01/2024." I used =RIGHT(Comments@row, 10) to get the Date of Last Attendance. I need to determine how many days it has been since that date using today's date, and divide…
-
Individual Resource Calendars Built in Project Schedules
As a PM I would Like to Create PTO Calendars for my Resources or Project Calendar, so that it will Not Schedule work on those Days for those Resources. Today I have Manually Look at there PTO Calendars (External App) and Adjust My Project Schedule. This is Time Consuming and inefficient. Thanks
-
Automatically adding new row data to formula
I have a few formulas on the top 3 rows of my sheet that are KPIs for the sheet. Since they consume the top few rows, I cannot select the entire column in the formula or it returns an error of Circular or Blocked. So I need to start the range with (ColumnHeading4:ColumnHeading99) and I cannot figure out how to always…
-
Select specific person/email as the name for automated alerts
This idea was created from comments split from: From email name for Smartsheet automations: select a generic value versus owner. While the current functionality of automated workflows enables the creator of the workflow to select if the email should come from a generic label (such as either Smartsheet Automations or their…
-
Is there a way to copy or link an attachment from one Smartsheet to another?
I have two smartsheets. The first, Order Sheet, collects submitted order info from a smartsheet form. The second, Shipping Sheet, has shipping info for both submitted and other/autogenerated orders . I am using Index/Match to pull shipping dates and tracking info from the Shipping Sheet into the Order Sheet. I would also…
-
How to calculate networkdays for each month between a Start Date and End Date?
I have columns for Start Date and End Date. I would like to calculate the number of working days for each month within the date range specified by these columns and display the results in a different sheet where the months are listed as columns. Could someone provide a formula or suggest an alternative approach to achieve…
-
Can't figure out my issue with SUMIF
I'm certain I'm doing something wrong, but I can't figure it out. I'm trying to sum total revenue per Engagement Manager. I can get the total SUM and the COUNT of EMs, but not combined. =SUMIF({Drawdown Services Total},({Drawdown Services EM},=[Primary Column]@row)) Thanks for your help!
-
RAID Risk Matrix
Hi, I have the below matrix, is there any easy way to get the formula to do the various risk levels (low, medium, high and extreme)? I have attempted to try with AI the formula but for some reason starting with the last scenario of Extreme it stopped generating a formula.
-
Returning multiple INDEX/MATCH or COLLECT on separate rows
I have a sheet (call it "Master Sheet") with a column called "Item ID". The "Item ID" is a unique system generated field. This sheet has an other column "Status", Status is a single select drop down column. For sake of argument lets say one of the values is "TRUE". I would like to create a separate sheet (call it…
