-
Can you link a field in Summary data from multiple sheets to a report?
I am trying to produce a report of specific Summary data fields, across multiple sheets, and aggregate a list of that particular field. Any ideas on how to do this? In a nutshell, I'm trying to produce a report that will forecast target project delivery dates and I'm currently tracking those target dates in a Summary field…
-
#Invalid Data Type
Hello, I have a formula in my sheet summary that was working until recently. For some reason the formula is no longer able to count the months or years in the sheet. I also receive the error when I remove the [Current Month]# from the formula and try putting "11". Does anyone have any recommendations or see anything wrong…
-
Multi-dashboards, with same names, using single sheet summary
I am attempting to create 2 separate dashboards, for 2 different regions, from a single Smartsheet, using Sheet Summary. I can not seem to figure out how to name the summary fields the same or conversely alter the names once they are in the separate report and/or dashboard. Does anyone know a workaround for this? I would…
-
How to use a formulas to indicate current constellation in sheet summary
Hi guys, I have a sheet to indicates constellations by date, and I cannot find a formula to get current constellation based on today's date, can anyone help with this? Much appreciate!
-
Smartsheet percentage
I'm looking to add a percentage column in my Smartsheet but every time I do it gives me the opposite information. An example is- I would like it to say 0% since there are only 2 samples and both had issues.
-
How can I create a function that separates a string of words separated by commas into rows?
=JOIN(COLLECT([column1]:[column1], [column1]:[column1], ISTEXT(@cell), [column2]:[column2], =""), ", "). Right now, I have this function in my sheet summary to concatenate all strings that have text in column1 and has no text in column2. The output it gives me looks something like "task1, task2, task3, task4, task5, task6,…
-
Sheet Summary Formula
I have a formula that totals the number of sales per project manager broken down by month: =COUNTIF([Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 9) I need another formula to Sum those sales for each month based on the column "Amount Awarded." I feel like this should be a fairly simple formula, but I have not…
-
Looking to count the number of times a string of specific text occurs in a column
I want to use a count formula to determine the number of times a SKU occurs in an open text column. Below is the formula for the highlighted cell: =COUNTIF(SKU:SKU, CONTAINS("SKU2", @cell)) The value I am looking for is 3 because SKU2 appears 2 times in the 3rd row and once in the 2nd row. Any insights on how to count…
-
Update Request to Update Sheet Summary Fields
It would be nice to send an automation that requests an update to fields in the sheet summary.
-
Add Dynamic Reference in Formula
Hi, I'm creating a summary sheet, I have a few sheets with the same columns, and I want to add COUNTIF formulas to the summary sheet, I'd like to know if there's any way that the Reference should be a dynamic option, so if a user chooses on the Reference sheet from a dropdown column: Sheet 1, the formulas knows to use…
