Hello, I have this formula: =IF(AND([Completion Date]@row = "", [Date Range End]@row < TODAY()), "Past Due", "ALL DONE") I've tried a few things but I keep getting invalid operation, and I'm sure it's…
In calendar view, how do I get my all my text to fit? It won't wrap. When I export from Calendar view in excel, it comes to me in grid format. Exporting the Calendar view in an PDF format doesn't help…
So I'm using the Smartsheet backup tool on a linux server, it's very simply and looks great, you modify the properties file, run the jar and there's your backup. I'm trying to automate this backup usi…
I have a head scratcher here, thanks in advance for any help that anyone may have. My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the ac…
I'm trying to update cells via the API and one the cells is in a Dropdown list column. However, when the API tries to add a value to the cell. I'm getting a 1042, "The value for cell in column 7098131…
Hello, I have this formula to add 10 days to a date: =[Date1]@row + 10 Then I have this formula to leave blank if there is no date: =IF(ISBLANK([Date1]@row), "") I need to put them together so if ther…
I've created a sheet that we use to track our projects. For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks …
Hello! I have this formula that works great: =DATE(YEAR([Completion Date]3), (MONTH([Completion Date]3) + 3), (DAY([Completion Date]3))) But if my date in "[Completion Date]3" is blank it throws off m…
When i try to upload files to the smart sheet , any mail attachments or documents. I'm getting an error message and it doesn't allow me to upload the attachment.I have attached the screenshot of the e…
I'm looking to add a formula which will check the dates in modified and created columns and update the status column. If the modified date is today and is greater than the created date I want to popul…