-
Clone Workspace with link
Hello, I was going through the Smartsheet Academy and saw a page where SS displayed a link and if you select it, it would automatically clone a work space for you without having to manually clone. I'm currently making a dashboard depository of our workspaces we would like all employees to use as templates for projects to…
-
Hiding Or Removing Duplicates In a Report
Hi all! I have a report on a sheet that has many duplicate values, and for the sake of nice presentation I would like them hidden. To further explain my situation, I have a sheet I am referencing that has tasks, days to complete, the week of completion of these tasks, and finally the avg days to complete a task per week.…
-
#INCORRECT ARGUMENT SET on Index/Collect Formula
I'm building a dynamic dashboard with multiple filters. I'm making a Index/Collect formula that can read values on a source sheet based on the values selected via the filters. This formula should work and I've seen it work on other sheets that Pro-desk helped with, and they gave me, but for some reason, I'm getting a…
-
Unable to access Tech Support Portal
Hi there! I am attempting to contact Tech Support to submit a ticket but, I am unable to access the Portal. We are on an Enterprise Acct. It seems as tough I am stuck in a loop and cannot get past this screen. Selecting "Smartsheet" only causes the page to refresh. I have logged in and out of my Smartsheet account several…
-
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…
