-
Min Collect Help - date returning zero value
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
-
Cross Sheet Counting
Hello, I have two sheets. One one Sheet I have a column with a drop down of names. I have another column with a dropdown of yes and no. On another sheet, I have all the names as rows and 2 columns. One column is named Video Missed and the other column is named Video Grace. What I need to happen is this: On the first sheet,…
-
Exporting Smartsheet formulas
From my research, I understand there isn't a way to keep formulas when exporting from Smartsheet into an Excel document. I have a total of 50 columns with formulas and would think there was a quicker way to grab the formulas. So far, I've appended a "!" which turns the formula into text which does export. However, I'm not…
-
Can I copy/paste summary fields between sheets?
I've just added six sheet summary fields to a sheet. But I have to add the same six fields to another eight sheets. I've been looking in the posts here, and I don't see anyone addressing whether there's any way to copy/paste the
-
Symbol Return Formula
When I use a formula to return a symbol for example =IF([INC/DEC]@row = "INCREASE", "RED", "GREEN") It just returns the word RED I have the column set to symbol but still can't get it to work…
-
Pulling Original Due Dates from updated Due Dates Cell
I am wanting to track, months into a project, where I originally had set the Due Dates. I have 300+ line items and I would prefer not to go in manually to update a new column with "Original Due Date". Is there a formula to pull that information from cell history so I don't have to manually do this? I sincerely appreciate…
-
Expanding My Index to additional Sheets
I recently created a new archive file and want to update the formula so that it will also search the new sheet. Here is the current formula I have. it works on current sheets but not the new archive. Any help or suggestions would be appreciated. =UPPER(IFERROR(IF(LEFT([Excel PO Approval Number REQUIRED]@row , 2) = "PO",…
-
Can you use a form to allow users to select available time slot
We are trying to utilize a smartsheet form for recipients to select a time slot for a specific training we are doing. We are offering a training to some internal folks but are limited in seats for each session. There are 12 sessions, some on the same date just at different times. Will use form to - * Allow recipient to…
-
countif from 8 different sheets with data criteria
Hello, I have a head scratcher here, I have 8 different sheets that I am trying to pull counts from and only from a certain day. Example: All sheets have a date of outreach, all sheets have a outcome. I want to pull the count of all outcomes marked "Mbr Reached" from 12/02/2025 from all 8 sheets. Question: Is there a…
-
Inventory Tracker
Hi - I am looking to build an inventory smartsheet, but am having difficulty setting it up. I am not a guru... We want to input all of our inventory by barcodes (auto populating and grouping same-type products) into our main warehouse. From there, we want to scan those barcodes and deduct x amount of inventory to our…