I have a dedicated column "days to go" I'm trying to get the formula to take the networkdays between today and the start date (accounting for dates in the "holiday helper" column. This formula works b…
Hi Smartsheet Community, I am really struggling to get the right formula and have tried so many now I am losing it! I am trying to prepare dashboards for weekly project meetings based on SLAs. I need …
Hi - trying to make a Training Matrix for my company. "Matrix" sheet has the following columns: Row: (Auto-Number) Doc ID: (Text = document needing to be trained on) Employee 1: Check Box if they need…
Good Morning Smartsheet Community, I am trying to calculate % based off check boxes selected on each row. Below are the fields I am calculating and the formula being utilized. Formula For %: =COUNT(Co…
I have four sheets that I want to summarize in a separate sheet. If I am using an Index/Match formula, can I apply it to Child rows also? On my sheets, I have an amount columns, but some amount cells …
This is driving me nuts. Sheet1: {Sheet1_CC} = Course Code (Text/Number Column) {Sheet2_MRC} = Modify Replace Code (Text/Number Column) {Sheet1_AT} = A Task Dropdown list with restricted options (NEW,…
I have set up a project status report to automate expected deadline dates for certain project deadlines. My current formula excludes the weekends, but not holidays. What can I change/add to this formu…
I have set up a sheet that will house our jobs. It has been requested that each job have its own row, nestled under the customer's name. Our job numbers are derived by using the customer number, year,…
I have the following layout, and I am trying to sum the "Ordered QTY" column for all children within each parent in a helper column so I can verify that amount with the parent "Ordered QTY". Any help …
How do we append cell value with existing data.? for example. column source and target. target = target + source. so every value entered in source it should be appended to target with already existing…
