-
Fail to reset passowrd because of no response to the challenge CAPTCHA
Hi, I am a business license user, recently, I shared the report to the people. some of them feedback, since we forget the password, when they tried to reset passowrd by click" forget password", they got the message “ the request can not be processed becuase it does not include a response to the challenge("CAPTCHA"). those…
-
Adding to Inventory
I'm sure this is simple, but I've searched for a while and haven't found anything similar! I have a sheet set up to track each piece of marketing collateral. It starts w/ the beginning quantity (say 100 pieces) and deducts the number of pieces that have been requested (through a SS form on another sheet), then another…
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
The 25,000 cell reference limit is puzzling
Dear Smartsheet: I am a bit confused by the 25,000 cell reference limit. In my specific case I am simply trying to VLOOKUP from a table where I have 700 rows and 17 columns. That equals 11,900 cells which is less than 25,000 cells. So, why am I getting this error? It creates an incredible amount of frustration and…
-
Smartsheet Function - TODAY()
I use this function, TODAY(), to calculate days to an event or past said event. I've noticed that you have to open the sheet to update or probably more accurately get the TODAY function to be active and calculate. I use this day counts in a Dashboard and to be accurate, as mentioned, I need to open that particular…
-
Help with SUMIFS formula to display todays census
Hello, Every day three service line VPs complete a SS Form. The form's information indicates todays date, service line, and a census. I need a formula (I presume =SUMIFS) that tells me the census for one of those service lines for only 'today's date'. That sum then flows to a dashboard widget so leadership can view only…
-
SUMIFS formula returning #INCORRECT ARGUMENT SET: order of Range & Criteria?
Hello, I cannot figure out why this SUMIFS is not working. When I break up the SUMIF criteria, they both work fine. But when I put them together, I get #INCORRECT ARGUMENT SET error message. =SUMIFS({MH Client Profiles v2 Range 13}, "East", {MH Client Profiles v2 Range 16}, 1, {MH Client Profiles v2 Range 3}) All I want is…
-
Total Count for Specific Date Range from another Sheet
I am referencing a seperate SmartSheet that I have Admin rights on. I want to count the number of items listed within each specific date range was work by. I would like to then find out how many of those items have been completed. I have been trying to work with the following formula but it keeps bring back "0".…
-
Approval Workflow
I am wanting to create an approval workflow that requires different levels of approval. The number of levels depends on where the request is coming from. As an example request comes in that requires Director, VP, and CEO approval to proceed, but I do not want the next level to see a request that was denied by the lower…
