-
Can an error message generated by a formula be used to trigger a workflow?
I've seen suggestions in other forum posts that this does not work, but nothing conclusive. I have an index/match formula to link data from sheet 1 to sheet 2. If the indexed row in sheet 1 is later deleted (the project is cancelled, for instance) there is no longer a match and I get a #NO MATCH error in sheet 2. I want to…
-
Why isn't my COUNTIF formula updating?
I am using the COUNTIF formula to keep track of quarterly reporting status for clients. For example, I need to track how many clients have a "failure to report" status. The row that I am pulling the data from is a dropdown selection - which I have never had issues with before now. When I plug in the formula, it registers…
-
CountIFS for Parent Row Only
Hello - I am displaying some information regarding things that are approved, in queue or denied. But I am needing to only count parent rows and not the children for them. So the data collected are just for the overall brand and not sub-brands. Is there a way for me to make this happen? Thank you - Mmurray
-
Dashboard Chart "unable to display chart"
Good day, I am using the pivot table to populate a chart on a dashboard from 3 columns on a sheet. Salesperson, month, contract value. that translates to a single line per sales person that I use to populate the chart. It is designed to maintain a running total of what work the salesperson has requested to be booked versus…
-
index match crossheet
i have sheet A that will look at sheets Q1,Q2,Q3,Q4 TO CONFIRM IF THERE IS A MATCH. and if not to return no match =IFERROR(IFERROR(IFERROR(IFERROR(INDEX({Q1 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q1 INV 2022 Range 1}, 0)), INDEX({Q2 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q2 INV 2022 Range 1}, 0))), INDEX({Q3 INV 2022…
-
Can you have two countif formulas in one cell?
I created a quiz in forms, and I am trying to capture all the right answers in the row to one cell. I have 7 questions each in their own column. When I try to use the countif formula to capture if the answer to question one is right it works and puts a 1 in the questions right column. When I go to add another formula two…
-
Calculate total % for Children rows where % Complete column is being populated by a formula
I have a Status Column and % Complete Column. I am using the following formula in the % Complete column to auto populate the % Complete. =IF(Status@row = "Complete", "100%", IF(Status@row = "In Progress", "25%", IF(Status@row = "Not Started", "0%", IF(Status@row = "Out of Scope", "100%")))) But when I try to calculate the…
-
Restricting a form by amount entered on a monthly basis
I have a form that utilized for co workers to request use of our department credit card. Our card has a monthly limit of $2,500.00. Is there a way to create a form in smartsheets that would calculate per month the monetary limitation and include any other submissions total for that month and if anyone submitted a form with…
-
How to update info from multiple sheets to one master log?
Good evening. I am working on setting up Smartsheet to track engineering information for my company. Each branch has it's own sheet and one person responsible for logging data into this sheet. That data is then copied to a "Master" sheet for company-wide comparison. Most of the information is known at the time of input,…
-
Using multiple IF/Left Function
I have 3 column headers which are name, subsidiary and reviewer. Based on the first letter of the name column and the full name of the subsidiary column I want to assign a team member to the reviewer column. The first team member will be responsible for all name letters starting with A-L for subsidiary 1, the second team…
