-
If all = Competent then competent, if not, then inconsistent
Hi all, I need help with a formula. People choose their skill based on a certain topic: Competent Inconsistent Expert I need a formula that looks at all the children and determines that: If 1 inconsistent, no matter what else, show as inconsistent If all competent or expert, show as competent I am guessing it can be easily…
-
Countifs formula to count a value within a date range?
Our company has ongoing surveys and the raw data is organized by different dates (dates the survey was complete). We want to only count the cells for a particular date range in our calculations sheet to give us the survey results for that time frame. For example: I only want smartsheet to look at the surveys completed…
-
Timeline for projects
We have several projects with us, and would like to display them all together clearly in a timeline. Unfortunately I can not find a template or anything else for this, can someone help me? for example sth like this: Thanks! Best Dominic
-
Can I pull a report based on who has access to specific reports/dashboards for governance ?
In line with GDPR, I need to be able to pull monthly reporting on who access access to specific sheets. Is this possible?
-
Sheet summary - column formula
Hello, I am creating a smartsheet that aggregates the clubs that certain employees are in. That main component is done, and I am now using the sheet summary function now (mostly using COUNTIF) to link to a dashboard. However the number of entries on the sheet will change with new employees, which makes the sheet summary…
-
Vlookup functions not working on a Master Spreadsheet
My colleague and I, who do extensive work on a master spreadsheet that pulls data from many different sheets, are having a lot of trouble with the vlookup function on this particular sheet. We use the vlookup function in multiple different columns on the spreadsheet in question, pulling data from a different source sheet…
-
Is it possible to automate export of specific cells on a triggered event?
When our "Completed" column is checkmarked, we wish to export that row and its children rows to an external file such as .csv, Excel, or Google Sheets. If possible, we would also like to export the attachments for those rows as well as reformat this data. Is this kind of automation possible? Built-in, 3rd party…
-
Webhook events
My company is looking for a way to export a project's data (including attachments) when it is checkmarked as complete in our projects list sheet. We would like to append this information to an excel spreadsheet or a google sheet. The workflow that I had in mind is that when an order is checked as complete, it triggers an…
-
Hide Divide by Zero Error
Hello, I am having issues with creating the correct formula that calculates the average of the children rows while hiding the divide by zero errors for columns that do not have any data. Could someone please help? I tried the following =IFERROR(AVG(CHILDREN([Column]@row],""))) Thanks so much!
-
Median formula showing highest value from range.
Hi everyone, I have two sheets, a master sheet with cost data and a metric sheet with formulas to get a summary. In metric sheet, I need median value of certain items. I have used MEDIAN & COLLECT. Problem: When I updated the formula, I got the correct median value. But after sometime, the metric sheet gets refreshed…
