-
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
-
Wrong Date Showing, Seems to be 4 hours off the difference between GMT and my Time Zone.
As can be seen in the attached screenshot I have data that is brought into the sheet from a web form. A time and date stamp is attached at posting (this time and date is correct) however, the date column beside it that is derived from the function Created is not correct is not. This issue is on all of my sheets and seems…
-
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…
-
Can a Form have multiple entries and have them display as multiple lines on the smartsheet?
I have a form I'm using as a maintenance work order log. I have them fill out a form, which in turn fills out the order log. Is there a way to have them enter multiple parts and descriptions and have them populate on multiple lines in the smartsheet order log? If they do have to enter a form entry for every part they want…
