-
Formula to add leading zero to months 1-9 of the year only.
I need to add leading zeros to month numbers Jan-Sept only as sorting by month number does not work due to Months Oct-Dec starting with number 1. If I sort by month number, it comes up like this. 1 (Jan), 10 (Oct), 11 (Nov), 12 (Dec), 2 (Feb), 3(March) ... Does anyone have a formula for this?
-
Deleted column data, accidentally 3 DAYS AGO!! No email, warning and/or notice?!
I've been building the sheet I work with daily since 2019; the data is used for long term reporting, and finally, has enough data to start building reports/dashboards! I added a new column on Monday 11/20 (today is 11/22) and inadvertently deleted all the data in the column next to it; not the column itself, only the data…
-
Share 'meetings' data (data, time, name of the meeting etc.) from a smartsheet into MS Teams
Is there a way to share 'meetings' data (data, time, name of the meeting etc.) from a smartsheet into a calendar app on MS Teams? Our client is maintaining a list of meetings in a smartsheet with all the meeting data in the form of columns. I want to be able to draw that data into an MS teams calendar app so I can use it…
-
Why is my formula unparseable?
=IFERROR(COLLECT([Completed Date] - [LTP Conversion Date], AND(IFERROR(MONTH(@cell), 0) = Feb84, IFERROR(YEAR(@cell) = 2023, 0)), {CAD Support Type TD}, ="Long Term Project")), "N/A") The bold is what I want to subtract within the formula.
-
Smartsheet Application Zoom Function
Smartsheets does not support browser zoom levels under 90% and begins to misalign rows, columns, dashboard widgets and more. This is still an issue within the smartsheet application and continues to shift and misalign data and widgets. Specifically building a dash board is very challenging as the alignment tools made to…
-
Difficulty with number vs text format, especially when using primary column as match range
Currently I have a primary column in sheet 1 which is a value of 3 digits, all of which are numbers. These numbers are generated by the auto-number column type. I attempt to use this primary column as a match range to pull information with an index & match into sheet 2. Performing a test using ISTEXT on sheet 1, all…
-
Sharepoint site refused to connect in work apps
Hello , this embed SharePoint page stop working last week. I don't have any issue accessing the SharePoint original page. I guess this issue is related to Smartsheet workapps application. Does anyone know what it could be?
-
Repeating Data
I have a sheet that pulls information from a master sheet to keep track of dates. 3 columns are repeating data and have been for a few days now. Is there a problem with the formula? I have seen this happen before, but signing out and back in a day later, it usually fixes itself. This time, it has just shown the same value…
-
How do I get the Credly badge to display on my profile?
I got Core Product Certified about a month ago at ENGAGE. However, I did not receive an email with a Credly badge like I did for the Core App self paced learning. I also haven't received the badge here on Smartsheet Community. I'm not sure if this is an issue because I took the certification exam in person, but I'd love to…
-
NEED IMMEDIATE HELP ON A DASHBOARD ISSUE!
Can someone please help me overcome this strange issue in Smartsheet dashboards? I can't show it to my clients! The dashboards should be intelligent enough to display a clean arrangement! Further, we can't even reduce the point-size of these numbers... above each bar. PLEASE RESOLVE IT AS I MIGHT LOSE BUSINESS DUE TO THIS…