- 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…
- 条件求和公式返回#不正确的参数UMENT 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…
- How to at mention a specific slack account in a channel from automated workflow?
I just set up my workflow so that when a predecessor task is complete, it sends an alert on my team's slack channel. The intent of the notification is to alert the {{Assigned To}} team member that they can start their assigned task. Is there a way to @mention the team member specifically using their slack account name? I…
- 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…
- Offline Access Please oh Please....
Hello, I see that there are many other threads requesting this feature but nothing recently from Smartsheet staff saying whether or not this request is being taken seriously. Does anyone know if there are any plans at all for this to be added in the future? Not being offline is a major issue for us as we go to places often…
