-
Checkbox to equal 100% in % complete
I am attempting to do the following. If the "Completed" column has a check, in the checkbox, I would like the % Complete column to read 100% Here is the formula I thought would work using task 4.of the project. =IF(Completed4 = "Complete", "100%")
-
Return a sum using using sumifs and dates
My objective is to return a sum of all 'Work Hours' that are in a department (Wire in this example), that fall within a date range of the 'END' date that Smartsheet is reporting.. This formula returns a value, but I've checked manually, and I've determined the value is incorrect. I've exported a filtered view of the sheet,…
-
Saved Filters Issue Date Type Column
I'm running into a very odd issue with consistent filtering on a date column thats being generated from a formula: We have a column labeled "Filter date" that is set to Date (Restrict to dates only not checked) which has the following formula to trim off the date from a 2ndary column that is a drop down: =IF([Date…
-
Subtract List Of Parts from Inventory
Hi, I have a Inventory Sheet with list of items and also the quantity of each item. I also have products that use various items from the Inventory list, which I list in the "Products parts list", for example: Product #1 requirements = 2 Wheels, 1 axle, and 2 wires. And the way I have set it up now, every time when I sell…
-
Activity log for certain user
I have noticed on log history that one user has successfully logged in. I have full admin account, can I check his activity since last log in ?
-
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…
-
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,…