Best Of
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
Re: Change Formatting in Reports
This has likely been requested before, but it would be super useful to have better report formatting available, beyond the layout options (card, etc.) and different than the column and row formatting from the source sheet. Exporting to format means the data is frozen at that time (and why should we have to export a report just to reformat it?).
SModesitt