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.
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!
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
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…
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…
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
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…
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…
Hi, Is there a way to set a web form field to default 'Current User'? Like we can pre-filter a report for example. Cheers, Rick
I have a sheet published in Card View on our company Wiki page with Read Only - Full features. I'd like to have the ability to set the Published Card View to match how I have my sheet set up and not a generic Card View. For example, I have several lanes collapsed, 'All Levels' selected, Specific 'View By' selected and some…
