-
Leads and Lags / Fast-Tracking Project
Smartsheet could consider creating a formula to lock a specific cell since it is sometimes necessary to block a successor date; it is difficult to add leads and lags and not move other dates, for example, when used in projects with fast-tracking compression.
-
How to Count a value in a drop down / multi-selection list?
Hi, I'm wanting to count the total amount time this value "VAVE" is being assigned to a drop down column. I'm using a summary sheet to collect this data using formulas. So in the request type column(drop down list) I want the total in this sheet. I also want a total by the Brand. I keep getting an incorrect number, like 48…
-
Ignore duplicate rows in a report
Hello, We record certain metrics about our clients anytime they visit our physical location. This usually isn't a problem because they don't come in too often; however, there are a few times a year when they are scheduled to be onsite multiple times a day. This leads to their name showing up repeatedly on the report we use…
-
Can you use a COUNTIF formula to county symbols?
I have a list of goals for the year and we are using harvey ball symbols to indicate the percent complete an the red, yellow, green, gray balls to indicate the health/status of the project. I would like to display a report on my dashboard that shows the number of projects we have in each harvey ball stage and also in each…
-
How can I sum one column based on dates of another column?
Hello, I am trying to sum up the revenue generated during a fiscal year. I have one column titled "Payments Received" and another column titled "Date Received" and would like to tally the totals received for each fiscal year (July 1 thru June 30). I've attached a screenshot of the columns. I have been trying to build a…
-
Quantity deduction workaround
I want to deduct the total "quantity requested" in the "final stock of inventory" after selected the "collected" check box and also wanted to show the available stock before confirming the order, Please help me with the workaround/ formula to achieve this Currently I use this formula, =[Initial Stock]@row -…
-
Check a box if values appear on two sheets
Hi, I'm trying to check a box if a Sales Force ID on my source sheet appears on another sheet This is the formula I'm using but am getting an "Invalid Operation" error. =IF({Sales Force ID} = SalesForceID@row, 1) Thanks!
-
Calculate Average Days When # is 0
Hello, I'm trying to create a formula where we track the days go from sent to actioned on. We have a column where it get's the number of days from sales sent to sales actioned on and that's simple a subtraction. However, when I'm trying to get the average number of days it takes a lead to be actioned on by month I'm…
-
Calculate % complete with Date Range and Today's date
Hello community, I need a formula to return % Complete based on a start - end date range and today's date. So for example: Date Range: 06/18/23 - 06/30/23 Today's date: 06/26/23 As there are 12days in this date range, and today's date is day 8 out of 12, the percentage complete would be 66.6% Thanks in advance!
-
Check box selection - referring multiple sheets
I have multiple sheets(sheet1,sheet2,sheet3,sheet4,sheet5) with email id's and I want to cross check in one master sheet in one check box column, if the match found then it should check the checkbox. can we use index match formula to refer multiple sheets? I'm trying to delete the master sheet email address if any of the…
