-
When a copy row automation is triggered, is there a way to only copy certain columns/cells?
When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row? I saw in a post from 2020 that this was not possible yet. Is this possible now in 2023?
-
License Request Form
Hi, We have enabled the Custom License Request Screen and included a form they can fill out for approval, but many are just clicking the green button because they think it's necessary. Is there a way to add automation so they receive the form via email when they click that button?
-
Moving Data from one sheet to another
We have a 'Request for Quote' process where a customer will ask us to quote them on fabricating some weld work. We place this information in a sheet "RFQ" Sheet, with Unique Quote Number, Product Name, Start date, End Date, Company requesting quote name, Project Manager Name, Internal Project Manager Name, Outsource Needs,…
-
True/False formula?
I'm trying to figure out a formula to note a "1" in the cell if the information in the cell next to it is a certain value, any other value needs to show a "0". Is this a "true/false" formula? I figured this out: =IF([Question 1]@row = "2. I should avoid using the electronic device during the initial connection; however,…
-
Hide comments in a published report?
Hi there, Is it possible to hide comments in a published report? I see this is an option when publishing a sheet as "Read only - HTML", but this option does not appear to be available when publishing a report. There are comments in our main sheet that the report is built on which we do not want to be visible in the…
-
Calculate days since a post opened that stops once a hire date is populated
=IF([Actual Start Date]@row <>””, NETDAYS([Req Open Date]@row, Today()), NETDAYS([Req Open Date]@row, [Actual Start Date]@row)) Hello! I'm trying to calculate # days posted using the formula above but its unparseable. Can someone help tailor and clarify what was wrong?
-
Dashboard Widgets Not Moving and Dashboard Freezing
I am using a dashboard and the widgets will not move. It might move a tiny bit, but then the dashboard freezes and I cannot save and it takes several minutes to refresh. Both the owner of the dashboard and I have the same issue for two days. Tried: via the web and the desktop app; disabling extensions; log out; restart. I…
-
How to retrieve the username of the person filling out a form?
Hello, I'm currently learning to use Smartsheet and its features at my job. I'd like to know if it's possible to automatically retrieve the username of the person filling out the form in Smartsheet? I tried using the 'Created By' column, but it refers to "web-form@smartsheet.com" when a new row is generated after form…
-
Linking cells between multiple project sheets
I would like to link cells from one project to another, but the option is grayed out (not available to select) when i right click on the cell. Any suggestions? thanks!
-
Sort by Priority - High, Medium and Low
Hi Team I have a Priority Column with dropdown High, Medium and Low. Since these cannot be sorted based on actual priority on Smartsheet Report and hence on Dashboard view, I have added a IF helper column that matches High to 1, Medium to 2 and Low to 3. Issue being, when I sort the SS Report by this helper column, project…