-
Nested Parent Child Column Formula
I have a field that indicates it is the parent row. Header is the column name. It is a check box. So I am trying to get this formula working is giving me an error. =if(heading@row=1,[Group Attendance]@row + 1,if(complete@row=0,Parent(@column))) I want to show the total credits for attendance in the parent row field, and…
-
Pie Chart from Two Sheets
Hello I have two sheets that are in effect the same - same column headers etc, but different source data feeding in. I have a sheet summary on each. For example, if column 1 has a yes/no option, I do the following on each sheet: =COUNTIF([1. Internal Process]:[1. Internal Process], "yes") I now need to be able to combine…
-
Making a Condition Based Only on Match
If Index/Match is asking Smartsheet to "Insert value1 from Sheet B into A, where Value 2 on Sheet B matches Value 2 on Sheet A" Is there a way to ask Smartsheet to "Insert Yes if Value 2 on Sheet B matches Value 2 on Sheet A". So instead of inserting the indexed value, it is inserting a newly generated value you want only…
-
Can you automate sending an attachment when a form is submitted?
Once a user completes a form, I'd like to automate sending a follow up message with an attachment for them to complete. Is it possible to add an attachment via the automated message or through an automation? I don't see a way to attach/ add a hyperlink. Thanks!
-
How to change star symbol to number equivalent?
I want to change the number of stars in a symbol column to a number equivalent in a column next to it, but do not seem to have the formula correct. It looks like it is a valid formula, but all I receive back is a blank. Here's the formula: Any thoughts on how to make this work would be appreciated. Thanks, Bill
-
Help with a NETDAYS formula
I have a formula in my sheet that is counting the days of an assignment since it was assigned. I would like it to stop counting once the row is marked complete or a date of completion is added. For example, in the screenshot below, the 37 in row 4 should be a 36 since the "Date Completed" column is filled in and/or the…
-
Project IDs and Data Mesh: How do get Data mesh to grab the newest data in a sheet, not the first.
I am building out my organization's portfolio. I have a series of helper sheets that move data through the backend depending on the review venues and approval processes the project may need to go through before it get's its project ID. (See flow chart below) Once a project has been given final approval the row is moved…
-
Running Count with Specific Criteria
Hello! I have a spreadsheet with different projects and their statuses. I'd like to make a running count of projects with certain statuses indicating they're still open (there are statuses indicating they're closed). I'd like to show a running count of how many open projects there are. There are six statuses indicating…
-
How to count total number of requests submitted?
Hi, I am trying to find a formula to count the total number of requests submitted in my grid. I want the formula to count the number of request ID's displayed. I want to use this number so I can display a metric on the dashboard. I also want to use a formula to count the number of "In Progress" requests and use this to…
-
Need assistance with Resource Management formulas
I've got a sheet going that lists all of my active projects. Each project has a deadline (in its own "Deadline" column, Archives Department remaining hours (in its own "Archives Hours Remaining" column), Digitization Department's remaining hours (in its own "Digitization Hours Remaining" column), and Platform Department's…
