-
Creating Sub-Auto Numbers
Hello, We are currently using a web form for customers to submit a service request. After the form has been submitted a auto-numbering confirmation is generated and the customer is sent a notification with that confirmation number. When we process the request we often need to split the service request into multiple…
-
Labs- Smartsheet Charts
Hi, I have created a few charts on smartsheets labs, i am however getting this error on certain columns: All series on a given axis must be of the same data type These columns are the only ones to have negative values (-30 etc). So my first question is does the smartlabs charts allow negative values. My second question is…
-
modifying formulated cell in a report
In our main sheet, we have several simple Sum formulas for numbers and some for dates. We have several reports created that contain columns with the formulas. While in reports, you can change some data in each cell that will carry back to the main sheet and save. Other data is not allowed to change (even if the column is…
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
Color Changes and Filter Bar?
Perhaps I'm loco, but 02/13/18 during the morning hours, I did not notice anything unusual about my landing screen colors. I log on after I get home, and my open tabs are now Orange and blend in too well with the background, and I now notice a Filter bar. Was this an update? I don't like it. Can we please get another…
-
Pie Charts in Sights
Hi, Thank you so much for adding Charts to Sights! It appears as though the pie charts can only handle three data points, is this correct? Or am I possibly doing something wrong? Thank you!
-
Troubles when Posting
I keep on getting this message when I try to post a question about some formulas: "Your submission has triggered the spam filter and will not be accepted. If you feel this is in error, please report that you are blocked." Yet this post seems to work fine. Any ideas on what the problem could be?
-
IF Function Due Date
I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days with the due date, I would like it remain yellow until a date is entered in the completed column, then I would like it to…
-
Outlook app - can't log in
I am trying to attach an email from Outlook to my Smartsheet project. I have Office 365. I can click on Smartsheet within Outlook, and it asks me to log in to smartsheet. Upon doing this, the Smartsheet wheel inside my email just keeps spinning and nothing happens - I have waited up to ten minutes to see if it will connect…
-
VLOOKUP #INVALID DATA TYPE
I'm trying to use VLOOKUP for the first time, and perhaps I just don't understand how it all works. I keep getting an "invalid data type" error. Here's my formula. =VLOOKUP(Workorder10, {Platform MPS Range 3}, {Platform MPS Range 4}, true) [Workorder]10 is the workorder number I'm attempting to search in the {Platform MPS}…
