-
Formulas
Hi, I have a formula that works perfectly in Excel but I can not get it to work in Smartsheets. I am having issues finding corresponding functions in Smartsheets. This is the formula and screenshots show what I am getting from them.…
-
Webforms email
I love being able to set the "send me an email" to checked and create a default email address. i use this so that someone (not the sender) gets the summary email with every submittal. But it would be even better if I could make this hidden so that the user does not replace the email with his/her own email. Or have a…
-
#Invalid Operation
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 something foolish and easy but I can't seem to figure it out. Tahnk you-
-
Seeing all my text in Calendar view.
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 becuase I cannot manipulate the text so that I can see it all. HELP!
-
Automated backups of sheets using tool
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 using Crontab but it seems like the backup tool looks for the properties file from your current directory, obviously in…
-
Parent Date Roll ups - Possible for two sets of dates?
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 actual dates on the project tasks. In my project settings the estimated dates are linked to the dependencies. When I enter in…
-
Is Picklist always Strict through the API?
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 7098131356849892, beagle, did not conform to the strict requirements for type PICKLIST." However, I've checked the sheet, the value…
-
How to put together two formulas to account for blanks
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 there is a blank the cell stays blank but if not then it needs to add 10 days to the date in [Date1]@row. Thank you!
-
How to tell if Multiple Invoices have all been processed
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 are sent out to our partners there is a column that indicates the date the invoice processing is complete. I've created a…
-
Counting for a Blank Cell
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 my whole formula. What can I add so it stays blank if I have no date in "[Completion Date]3". THANK YOU!
