-
Right-away notifications not being emailed
I have setup a separete hidden checkbox column for each member of our team with a notification to send an email to each person when the column with their name is checked. The email is to go out righ away, when their column is changed. However, I have been changing and saving and no email has been sent out...some are…
-
Can we change default text of Subject and Message fields of update request?
Is it possible to change default text of Subject and Message fields of update request with my own text? I don't want to type these texts every time I send an update request.
-
Chart Live Update
Hello, We are experiencing an issue with the chart functions within Smartsheet. We are currently using Smartsheet to collect and process help desk tickets. We have a form hosted on our intranet where users can submit help desk tickets. Those are collected and processed by our help desk team all in one sheet within…
-
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…
