Best Of
Re: Licenses and True-up confusion
Thank you, not really helpful at this stage as there is an additional charge for Premium Apps (not mentioned). I will seek another solution outside of Smartsheet. This must be chaos for numerous users and I hope customer feedback is being listened to. I don't believe there is much more you can help with other than reversing this ridiculous decision.
Re: Create Formula in Sheet Summary field to pull only Month from another Sheet Summary Date Field
Hi @MariaG
Thats fine, if we add another IF using ISBLANK at the front of the formula we can achieve that.
=IF(ISBLANK([Projected completion date]#), "Undecided", IF(MONTH([Projected completion date]#) = 1, "Jan", IF(MONTH([Projected completion date]#) = 2, "Feb", IF(MONTH([Projected completion date]#) = 3, "Mar", IF(MONTH([Projected completion date]#) = 4, "Apr", IF(MONTH([Projected completion date]#) = 5, "May", IF(MONTH([Projected completion date]#) = 6, "Jun", IF(MONTH([Projected completion date]#) = 7, "Jul", IF(MONTH([Projected completion date]#) = 8, "Aug", IF(MONTH([Projected completion date]#) = 9, "Sep", IF(MONTH([Projected completion date]#) = 10, "Oct", IF(MONTH([Projected completion date]#) = 11, "Nov", IF(MONTH([Projected completion date]#) = 12, "Dec", "Error")))))))))))))
Hope that helps
Paul McGuinness
Central Operations Manager at Care UK
If you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.
Paul McGuinness
Importing Excel Sheet to Update Existing Smartsheet
Hello,
I am trying to be able to create an Excel spreadsheet with corresponding header fields. For example, headers in Excel would be "Order #" and in Smartsheet it would also be "Order #" so that whatever is under those header fields would auto-populate into Smartsheet.
Whenever I try to import an Excel sheet it creates a whole new sheet, but I am wanting to add new information to my "Open Orders" Smartsheet multiple times a day.
Thanks for the help.
clairehunter
Re: Formula needed to fill a cell if a word is contained as part of another cell
Hey @SSParks
HAS is an exact match. Sorry, I wasn't paying attention that the screenshot was truncated. CONTAINS would catch a portion of the word
Kelly
Kelly Moore
Re: Dashboard Charts - Secondary Axis, additional data points, target line
We would also love to see these features added to the charts. The ability to add a goal line or to mix different types of charts. It would also be great to be able to select which datapoints you combine into a stacked bar chart while still being able to have one that is not. Anything to increase the functionality of the charts would be fantastic.
RebTrachs
Re: Adding Column Descriptions to Reports
Absolutely agree. This seems like very basic functionality to add which would have very meaningful impact.
nbuikema12
Re: Adding Column Descriptions to Reports
This wouldn't work when you have more than one sheet as the source of the report. But for single-sheet reports, it makes total sense.
how do I change my email address because I have no access to the current/dead email.
how do I change my email address because I have no access to the current/dead email.
212004739
Re: NEW! Modern forms submission experience with accessibility enhancements
I've experienced the dropdown field selection issue myself this morning. Trying to select a staff member from a single select drop down > started typing staff member name and hit return instead of grabbing my mouse to select > field in form stayed blank, would not reset to display dropdown list again > had to close out and reopen the form to reset and display the dropdown list again.
Sarah Donnelly
Re: NEW! Modern forms submission experience with accessibility enhancements
We are also experiencing huge usability issues. Longer drop down select items on mobile are formatting in such a way that all items are illegible on mobile. We need this reverted, or an option to change formatting styles.
WerkinGrg22