-
Formula
I am trying to use the below formula to have an average of answers but it is not working can anyone check the formula and let me know what is wrong =((COUNTIF(CHILDREN(), "Excellent") * 5) + ((COUNTIF(CHILDREN(), "Very Good") * 4) + (COUNTIF(CHILDREN(), "Good") * 3) + (COUNTIF(CHILDREN(), "Fair") * 2) +…
-
auto resizing widgets in Smartsheet reports
Hi there, I'm creating dashboards and they are working well, but one annoyance is that there are many occasions when the data displayed in the report widget, is bigger (usually longer) than the widget frame. Is there a way to set the widget to auto size based upon the number of rows brought back? Many thanks, Matt
-
Cell lookup and linking from another sheet
Good Morning All! Here is my dilemma if anyone can help. I have two worksheets. One has employee ID numbers and a box checked if they have a certain certification. Is it possible to create a formula that essentially says if box gets checked in worksheet A, look in worksheet B for name and check box in worksheet B? Or if a…
-
Copying Alerts & Actions from sheet to sheet
Hi all, I have a set of 5 "Alerts & Actions" that I need to set up on 32 different sheets. Is there a way of "copy and paste" those rules, instead of manually set them up on each sheet? Thank you.
-
How to easily capture Actual Time spent on a Task in SmartSheet?
Fellow SmartSheet Community Members, We have recently started using SmartSheet for planning out a roadmap for initiatives, along with types of roles allocated to the initiative (resources) as well as allocation. We are now looking for creative ways to capture "Actual" time spent on a particular initiative. Here are our…
-
Summing of colored "conditional" cells
Hello All, I am trying to count or sum how many colored cells there are within a row. The rows consist of test questions and are set to turn red if the condition is not met (answer is incorrect). Is there a way to sum all of the condition not met cells? There are 25 cells that have conditions in them.
-
Feature request: company holiday management in Workspace
Hi there, I've seen some discussion on these boards about managing non-working time. It seems there's two out-of-the-box options, either to have each individual project manage their time or have a sysadmin do it at a global level. Some have suggested blocking time using a dedicated gannt chart. For larger companies across…
-
How to create an auto incrementing number based upon checkbox
Hi everyone, I have a smartsheet where each row represents an "installation". One of the columns is called "Gone Live" and is of a type checkbox. I have created another column entitled "Number of Installs this year". In this column, I want to create a formula that checks the "Gone Live" field, and if the checkbox is…
-
Divide by Zero error
Hello, I have the following formula to calculate % Over/Under Budget: =[$ (Over)/Under Budget]8 / [FOOD BUDGET July 2018]8 I would like this to work even when there is a 0 in the Budget number and even when "over/under" is 0. Thank you for your help. Todd
-
Activity Log
Dear Users Can anyone help me to figure out how to see activity log ? The icon is missing from my sheets ( did this happen during a software upgrade ? im not sure ) I want to see who is accessing my sheets