-
Calculating hours:minutes from cells with date and time
Trying to calculate total time (preferably in minutes) spent at a task/site. Arrival and departure "times" are written in date-time format - so (arrival) [2/28/19 9:15PM] in one cell/column and (departure) [3/1/19 2:25PM] in another cell/column. If it helps, those cells were created by combining multiple columns - date…
-
Is the Today function actually being forced to update?
The grid below shows 3 rows. The 1st, Header_Row, is a place holder row for the Today function entered in the 1st cell of the Date.Today column. This allows the formula to be copied down when subsequent rows are added to this Smartsheet. Using automation, the "Delete_Task" row is copied into this sheet from another source…
-
Counting Grandchildren Rows based on multiple criteria
Hello, I am trying to count grandchildren rows based on 2 column criteria. My parent row is different task orders and underneath are multiple children(Hospitals) and the children all each have children too (quarters). For each quarter, I need to count the number of grandchildren in that quarter that have a date in my "Date…
-
Data Uploader Filtering
Hi All, Just a quick question regards the filtering in Data Uploader. I'd like to look at everything incoming from the report I pull for the last 30 days. Having already mapped the columns, I'm just wondering what would the correct formula criteria be. Incoming equals TODAY()-30 - or something similar? Screenshot attached.…
-
Formula comparing dates
I am very new to Smartsheet and the making of formula's overall so sorry for this question. I want to create a column where it will be highlighted when the date from column x is 4days or less apart from the date from column y. Does anybody know which formula to use? I started with this: =IF([column x]row number < Many…
-
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…