-
Using IFS statement with date and check box
The simple statement is I want to have a sum of work hours in a department, that is still incomplete, during a calendar period. Currently the formula is: =SUMIFS([Work Hours]:[Work Hours], Department:Department, "Wire", Finish:Finish, >=DATE(2020, 9, 1), Finish:Finish, <=DATE(2020, 9, 30)) * 8 A suggested version has been…
-
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…