-
Forms and column consolidation
We use Smartsheets for Project management in our org, but I would like to see it expand to other areas, such as Marketing. We have an internal webpage where you can put in 13 different various marketing requests that currently utilizes a different system. For ease of use, I had thought perhaps consolidating them all into…
-
How do I exclude information on a report that uses two sheets?
Hi Smartsheet Community, I'm currently managing two sheets for a non-profit organization, and I'm seeking some guidance on how to generate a report for their fundraising events. Sheet 1: Checkbook - This sheet lists each disbursement, daily total deposits, and the checkbook balance. - It includes a dropdown column with a…
-
Form - Restrict access to a domain name
Hi, I am re-activating this question that was asked a few years ago on restricting access to a web form to a domain name (or specific group). We have developed a service request process using a smartsheet form for users to send in requests. Has there been any development since at the admin console level to restrict access…
-
Change <60 Days to search by month
So I have this formula which searches the past 60 days. =COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Pictures", {18b Issues…
-
Sheet setup for scalable data
Looking for a best practice to set up a scalable (target vs. actual, month-over-month) sheet - There are 15 specific varying metrics (e.g. numbers, $, %) collected monthly by different people. Each metric will require both actuals for the prior month and a target for the next month. I would like to show both monthly…
-
Create URL to single row in smartsheet viewable by non-users
Hello, I am awarding student micro credentials, and one requirement is that for each badge award I include a URL to the student's assignment submission (attached to a row in smartsheet) and a few other pieces of information. I have all this information stored in a single sheet, but I only want the link I create to go to…
-
workflow, not seeing other sheets
I've been added as an admin to an original sheet, I'm trying to create a workflow to copy lines, that meet a certain criteria, to a sheet I've created, but when I'm in the workflow I see no other sheets to be able to copy the lines to. I've created similar workflows before and have not had this issue. The only difference…
-
Can't delete columns on shared sheet
Every time I try to delete old columns on my smartsheet, after I save and refresh the page, the columns come back. This sheet is shared with several people and it is SLOW. I was hoping getting rid of unused columns would help out the speed but I can not find a way to actually delete them.
-
Date Column
I have a task that I would like to populate periodically in a 1-2 calendar (for example: this task happens every other month). My date column only allows for 1 date.
-
Workflows and Notifications
Hello, I am building out workflows to be triggered daily on a couple different forms. The notifications are working correctly on one form. I tried building out the same workflow but on different sheet/form and the notifications do not send. Is there a way to resolve this?