Comments
-
use countifs formula to exclude the rows that contain the "Y" =COUNTIFS(Health:Health, 'Medium Risk", Exclude:Exclude <> "Y") to get a percentage =COUNTIFS(Health:Health, "Medium Risk", Exclude:Exclude, <> "Y") / COUNTIF( Exclude:Exclude, <> "Y")
-
Use "CountIfs" instead of "and" =COUNTIFS([Column X]: [Column X], 1, [Column Y]: [Column Y], 2, [Column Z]: [Column Z], 3)
-
Dustin, Great solution - and very timely for me as I was just looking to solve this problem today I took the added step of using the picture widget, took a .jpg snapshot of the document and used the advanced settings to go to the document URL. Now a user can click on the picture and download the pdf. Thanks, J
-
It works if i uncheck the box and save the sheet and then check the box and save again then the move works as expected. That action of course clears the formula out of the cell It must have something to do with a formula creating the check mark. The automation process is likely looking for a cell value 1 or 0. I'm assuming…
-
解决了…我可以to make it work in a roundabout fashion using Zapier, Google Docs and two smartsheets. Add an Auto Row number column to your Smartsheet Intakes information/requets from a Smartsheet Form Zap #1 - Zapier moves the number I want to convert to words and the ROW ID number to a Google Sheet Using Google…
-
Hi Andree, Thanks for responding. I messed around with Zapier for a couple of hours and could get it to work halfway. I can get the Zap out to Google Docs and run the conversion there, but am having trouble bringing the result back into Smartsheet, but I am admitadly a novice at Zapier, so i will keep playing with it. I…
