-
Search a data column and return the most recent past Saturday.
Have not found this in the community, videos, courses, or formula template. CONTEXT: I have a dashboard that updates weekly. It has weekly data and a rolling 13 week chart. The date column is a Saturday (weekending date) and the team completes it when they come in Monday for the week prior). I have a data collection sheet…
-
Formula to split up / break down long strings of text
Hi, Hope you're all keeping well. I was hoping someone could point me in the right direction of a formula / function that can help break down large sections of text. If someone could point me in the right direction, I should be able to work out the nuances and implementation myself. I have an API that exports data into a…
-
SUMPRODUCT Workarounds?
Hey all, I'm evaluating Smartsheets for my business and trying to determine whether workarounds exist for some necessary calculations. Three big ones are cost calculation, weight calculation and inventory management. I currently use Excel for these. My arrangement is I have all our products on the top row, with all of our…
-
Automatic Predecessor Adjustment
Hey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with the fabrication packages released from the Eng Dept. Sometimes the schedule needs to…
-
Formula - Return month as text from a date cell.
I want to use the formula: =TEXT(*CELL WITH DATE*,"mmmm") But this doesn't seem to be a valid formula on Smartsheet. So if I have a cell with the date "01/01/19" - I want it to show "January" in another cell.
-
Logging time on hold
Hi, I am looking for a way to log the time a row's project status column is changed to on hold and then stop counting when the status is changed. It would be possible for the project to go on hold multiple times. Any help would be much appreciated. Thanks!
-
Attachments & Proofing
Hello, To proof I have to first upload a file, but what if the file had already been attached to the row; is there a way that an attached file can be automatically moved into proofing. Thanks
-
Barcode scan and update columns on line
Is it possible to scan a barcode-find the line where the barcode is already on and then put a check mark in to update the status of the line? Basically I am scanning a a product into the Smartsheet. It will create a line in Smartsheet that has the barcode scan and then a date. Later in the process I will be scanning the…
-
User type: Editor can share
Can someone help how licensed user type "Editor can share" is not able to create folders but only onwer? a few days ago it was possible
-
Duration as a formula to accommodate resource allocation varience
I have three columns in my schedule sheet. Duration (native column) hours and resource allocation. I would like the Duration to be my hours divided by my resource allocation. So If I plan to put 2 people on a 80 hours project my duration is only 5 days not 10. I tried a formula in my duration column but it doesn't allow…