-
Formatting when exporting to pdf
Hi, Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email. Lauren
-
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…
-
Workflow - lock/unlock rows
Hello, First of all thanks for helping :) I have this list of tasks where i use my WFIndex + Index columns to identify them and execute automations. My Milestones are "locked", colored in blue and in this case identified by WFIndex = 4 (row 8) I have a few "checks" which i want the user to mark as "completed" before…
-
Calendar App - Filters...why did you change the functionality...now...during a Pandemic?!?!?
Smartsheet, Before I lose my mind, here... please tell me that there is (at the very least) a way for individual users to create filters without being shared to the underlying sheet. Up until this change, our users were able to access the calendar and manually select the criteria that they wished to view via multiple,…
-
FORMULA NOT WORKING
HI, I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you in advance :)
-
=SUMIF Month-to-Month
I am trying to create a graph for a Dashboard that will display the total amount of approved $$ within each month and total amount of denied $$ within each month. I will also need a rolling YTD total. So far this is what I have for the formula: =SUMIFS({RSA Form Range 2}, {RSA Form Range 9}, "Green", {RSA Form Range 3},…
-
Managing user permissions for OneDrive folders in Smartsheet
Hello - I am new to Smartsheet, so I have A LOT to learn! Since attachments are not stored locally in Smartsheet, I need to save files requiring updates in OneDrive. Rather than maintaining OneDrive access separately, is there a connector that will allow me to manage access to OneDrive based on contacts that I have invited…
-
Return Same Vlookup for certain day.
Basically what im trying to do is a project tracker. When the guys do a project they spend a certain amount of hours on it. thats all good until the project is paused and restarted again i have a issue where it calculates off the closest date. So what I tried to do was if the project start was on the same day as the finish…
-
Request Tracker Form
In Request Tracker, How can I change the default value of department and Request type? How can I put the department and request type in this form?
-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focused data, data that should not be managed on an International sheet that already has 85…
