-
Building a Master Sheet using Copy Rows
Hi all, I have ~40 Project Info Sheets that are used to build an executive dashboard and populate status report dashboards. Each of the Project Info Sheets are distinct to the project and then roll up to the report(s) to provide the portfolio level view. Active Status is indicated by an 'Active Status' checkbox and can…
-
Need help with RYG status formula.
Hi, I am using this formula currently to change a harvey ball based on dates. It is currently working, but I am modifying my sheet to include rows that I want to ignore for now, meaning that some date fields will be blank. I would like for the formula to return no harvey ball color when there are no dates in the cells to…
-
Move Rows Error
Hi, This workflow used to work fine. I moved some sheets into a different workspace and now it won’t work no matter what I do. I have deleted the workflow and recreated and it still is not working. Has anyone seen this error or know how to fix it? Below is an image of the workflow. Attached are the source and target…
-
Check off completed if items collected, with different number of items needed to be collected.
Hi, I'm trying to make a list of people and items I need to collect for them. Sometimes I need to collect 1 item, sometimes 2 or 3. The last column I want to write a formula that will check the box if everything is collected for that person. Since every situation is different and I need to collect a different number of…
-
How do I create a SUM based off of specific criteria?
I created a smartsheet to track an assistance program. I created a column with color-coded dots (RYG Balls) to represent the status of each application. These dots are changed manually as the application status changes. Red dot (declined), Yellow (Pending), Green (Accepted), and Blue (Completed). A different column has the…
-
How do I create a formula to activate a flag if a column has not been changed?
I want to be able to send an automatic update request when people fail to add updates to a text column (Called Updates). Currently, this doesn't seem possible. But I thought of a workaround that may work if someone could point me in the direction of writing a formula. I thought of having a flag column that will go up if…
-
SUM(CHILDREN)
I have a formula that is using VLOOKUP to pull an item's price from the Price List sheet. It need to account for 3 possibilities: The product is in our database - in which case the VLOOKUP work The product isn't in our database - in which case it says there is no price in the system The line is a PARENT row and doesn't…
-
"Contains" Cross-Reference Formula
I have two Sheets, one with a list of full course master names (e.g., ABS-435-BL-6W-1D-Master), and another sheet with a list of course sections (e.g., ABA 435 BL 6W). Is there a way to use CONTAINS in a cross-reference formula to check all of the course master names in Sheet 1 to see if any contain the cell value in Sheet…
-
Multiple if / and / istext
Hello Everyone I am finding a way to fit a new argument this is my current formula: =IF(ISBLANK([Logistics Validation]1), "New", IF([Logistics Validation]1 = "invalid", "Closed", IF(AND(ISTEXT([Logistics Personnel - Assigned]1), [Logistics Validation]1 = "Valid"), "In-Progress"))) need to add this arguments, logistics…
-
Formula lookup separate sheet to get more info after a SUMIF
I have a sumif formula that is working nicely to return the value of a payment that I am getting ZAPIER to add a row to a separate sheet that has all the payments. Formula: =SUMIFS({Square Payments Range 2}, {Square Payments Range 1}, [Participant ID]442, {BIP Online Payments Range 1}, <=[Group Date]442, {BIP Online…
