Community

Hi guys,

I have a new challenge for you :). I have a list of projects. Each project contains different products. I have one probabilty column that contains all the probabilities to sell the different products contained in each individual project.

An exaple: I have a project (1 row) where I can sell

Per the attached screen shot. How would the formula be written so that the row2 flag turns red IF any of the flags(row3-row11) are toggled to red?

https://help.smartsheet.com/articles/1155182-sharing-permission-levels#…

for reports the table has an entry:

Edit unlocked rows and columns (if they also have permission to the sheets) Editor: YES

Further down the table, another entry

Edit unlocked rows and columns: Editor: NO

(I suspect the 2nd

Hi all,

Having issues with my reports where the dropdown options that I want to update (in the report) are not functional.  I see that this has been a bug before and am wondering if it is happening again/if there is a work around?

I am compiling a metrics page, and need to count a date field, teh automated "created" which stores date and time the row was created.  I want to count a total of "01/XX/19", XX meaning i dont care about the days, i just want all of January 2019 entries.

I am refrencing another sheet (hence the

Adding row numbers to a report widget in a dashboard

I need to bring data from Smart sheet data into sql server using ssis. can anyone suggest the

Why we have a Business plan with 100 users/collaborators and the system is asking me for more licenses when sharing a Workplace with few peoples. Our Business plan has 3 Licenses. account

how can I exclude N/A on the count if N/A is selected

Formula:

=COUNTIF(CHILDREN(), "Done") + "/" + COUNT(CHILDREN()) + " (" + ROUND(COUNTIF(CHILDREN(), "Done") / COUNT(CHILDREN()) * 100) +

Hello,

How do I exclude the summary row in the following formula?

=" Yellow: " + COUNTIF(Risk:Risk, "Yellow") + " Red: " + COUNTIF(Risk:Risk, "Red")

Basically, the summary row RYG ball risk indicator should NOT be included in the risk count of the child rows because it causes a count that is one