-
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?
-
How to transfer a sheet ownership from a user that is not in my organization?
Hello! I'm trying to take ownership of sheets I am the admin of, it gives me the error, "you cannot take ownership of this item because the current owner is not in your organization". My account was part of the parent company business plan, but now our company got their own plan, so my email is no longer part of the parent…
