-
Help with Updating Rows Via a Form Submission
Hello, I am trying to use Smartsheet to track reagents, the workflow is as follows: The person prepping the reagents fills out a form with the pertinent information and the number of vials made. in this example the person made 40 vials. I would like to have this same number decrease via form submission. Example.) 1 vial is…
-
Checking a box based on data from a cell in a different sheet
Hello, I have two sheets. On one I have a column noting the status of a contract, in drop-down style. I would like for when the status is complete on this sheet, for it to check a box on another sheet. Is this possible?
-
Date Formula for Xth Day of the Month
Hi there! I'm hoping for a formula that returns the third working date of the month. I do have dependencies enabled, but none of my dependencies stem from this row. Seeing as how others will use this sheet monthly, it would be nice if rows like this autofilled monthly to avoid some manual work. In my dependencies, I have…
-
RankIf options (rank based on another value)
Hi all I have a sheet that lists usage metrics on specific items. Items are categorized by group in another cell. There are 82 different groups and I am trying to find a way to rank these items based on the usage metrics PER GROUP I need to create a RankIf formula and need you expert knowledge to help do this without…
-
Need a option to copy only changes for last 7 days
There is a good option to review changes in last say x hours and day , I would like to know how to copy all rows where last changes happened for that filter to only copy and paste to someone asking for delta work for last say 7 days ?
-
Successors
Hi, I'm struggling with my formula designed to find Successors for each row based on the predecessors column. I've almost got it working, but as you can see from the attached photo, in cells using the formula, rows that include one of the rows are also added. For example, on row 3 (successors), 31, 32 and 33 are included,…
-
how to extract currency from a string of text
similar to a bank statement 07-22 Point Of Sale Withdrawal MARTYS FI 61 MAIN 13.99 - SHOPKINTON MAUS 07-22 Point Of Sale Withdrawal PAN THAI 44.38 - RESTAURANTHOPKINTON MAUS 07-22 Point Of Sale Withdrawal ALS STATE STREET 10.00 - CABOSTON MAUS 07-22 External Deposit Resilience03WBZk C:42320H:03WBZk - 35.00 DIR DEP I want…
-
Looking for last date before today, referencing unique identifier
Hi, I'm looking for a formula that will reference a unique identifier (Unique Object ID) in a list of other Object IDs, and collect the last date but that is less than today. The following formula works to return the last date, but some return a future date which I don't want. I need the date that is closest to today but…
-
Week Ending Date on Dashboard - Automatic Update
Hello, how can I leverage the metric widget in a project Dashboard to display 'Week Ending X/XX/XXXX' that updates automatically? For example, for the week of 11/8/21-11/12/21, I would want the widget to show Week Ending of last week (11/5). When it becomes 11/15/21, I would want it to display 'Week Ending 11/12/21'. Do I…
-
Index only returning results if at the top of the source sheet
Hi All, Hoping someone can help me please? I am using the formula below but it will only work if the search value, System ID, is in the top rows of the reference sheet. =IF(INDEX({Reference Range System ID}, [Row ID]@row) = [System ID]@row, INDEX({Equipment ID}, [Row ID]@row)) What I am trying to do is, If the System ID in…