-
Linking reports to sheets
Hi Team, Is there a way to link multiple sheets (source data) to one report? I believe I can do this with dynamic sheets but we don’t have licenses to cover. Any ideas?
-
Automation - best practice question
I have a sheet with around 20 reports hanging off the back of it for a group of partners. When I assign them a task from the sheet I’ve setup automation to Emil them that there is new content on there report to look at. Is there a way to send a reminder or alert to an email address based on a cell change, therefor only…
-
IF statement - How to return a result from two multiple sources
I was wondering if there is a way to do an IF statement to capture a result and add that result into another cell? eg. from A1 (if C2 =“NSW” return “abc computers’ in B2) note - I can’t put the formula in B2 as this a drop down list. the only other alternative would be conditional formatting but smart sheets only gives…
-
Creating a new Group
Good Morning, I use groups to give staff access to the different sheets that I build, it makes giving large numbers of staff access to a sheet very easy. But...today I tried to create a group the way I have in the past, "Group Management" | Create Group | ... I name it, then add staff and I'm good to go. Except for…
-
Auto publish Dashboard as Screenshot
I can publish dashboard as link but how to publish sceen shot at scheduled interval of time
-
CheckBox Formula
Greetings! So, I have a "Done" column and a "Status" column. Status column values = Not Started , In Progress, Complete Done value = Checkbox The Goal: When I check the "Done", I would like to have the Status column show Complete. I have partially achieved this with the following formula: =IF(Done@row = 1, "Complete")…
-
Multiple Selection - Formula
Hi - I have a question re: a Multi-Selection Drop Down. Right now, our one multi-select has 120 options. More often than not, people select less than 5 from the drop down. When they select from the drop-down, I have to parse what they select into codes. E.g. - Selection 1 = Code 3, Selection 2 = Code 10, etc. I'm using the…
-
Check Box
Is there a formula or function that will check/uncheck all boxes in a column if one box is checked/unchecked. For example if top box is checked, it will check all the boxes in that column?
-
I've created templates of Sheet/Report and Dashboard Templates. If I copy them, will the link remain
I've created a folder containing templates for sheets and reports all linking to a dashboard for a status report. I want my team to be able to copy these and use them for their partners. How can this be done easily? If they create the sheets from Template and Save As the Reports and Dashboard, do they have to reset the…
-
Formula skipping rows
Hi all, I'm trying to use the below function to automatically change the color of Harvey balls to red, yellow, or green based on the length of time till a task's due date. =IF([Due Date]@row >= TODAY(+61), "Green", IF([Due Date]@row >= TODAY(=31), "Yellow", "Red")) However, for some reason some rows show "#invalid…