-
Anyone else have this issue with forms and know how to resolve?
I am having a problem with forms submitting into a SmartSheet. I've built a simple SmartSheet with some IF commands that apply a score based on dropdown menu answers. I also created a report that shows a selection of columns based on a field being populated. When I submit a form built from the simple Smartsheet, nothing…
-
link between sheets
Hi! I'm working with two different sheets. The first one has all marketing activities (webinars, events, trade show, etc). The second one has all the marketing assets created (Ebook, social media cards, etc). I would like to link which assets can be used for which marketing activities. A marketing activity can use more…
-
Header
I want to add a fixed header that displays above rows on my sheet. I see this is available when printing the sheet, but I need to add instructions and clarification to the published sheet that is viewable by collaborators.
-
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…
