-
Stop scheduled "send as attachment" with deleted reports
Hello, I have scheduled the "send as attachment" for reports, and now that I have deleted these reports, it seems like it's still trying to send as scheduled but with the below error message. We were not able to send your email "xxxxxxxxxxxxxxxx Report" due to an unexpected error. The Smartsheet Team How can I stop this? I…
-
Security Query
Hi, Disclaimer: not an IT person. I am in the process of assessing Smartsheet as a possible administration tool for work purposes and I was wondering if I can get some advice from international users who have used Smartsheet for storing personal information. I am outside of the US and the legislative requirements for…
-
Dynamic dates
Very new to this program so hopefully this is not a stupid question... I need to set a sheet up where there are fixed times within a 4 week cycle for certain steps to occur. For instance we can only order a certain pack on Friday of week 1 of any 4 week cycle. Is there a way to set this up so if the predecessor finishes ie…
-
#Invalid Operation Error subtracting days from another Date field
I have a sheet that has a date field that is link in from another sheet (actually 2 other sheets) that is not working as expected and I cannot seem to root cause the issue. I have a column 75%/SD Date that I want to get 14 days before it in another column. Below are some things I have put in for the formula and the result…
-
Is there a simple way to manage workflow approvals when the approver is out of office?
I don't want to have to go into each workflow and update when my workflow approvers are out of office, on vacation for example. Ideally, I would like the approvers to update the dates they are out of office and provide a delegate for the approvals that are received in this timeframe. Any approvals required during this…
-
Sheet summary can be added to a report
I have created a report from 3 different smartsheets to merge it in a single sheet report. This report shows in a single view all our Purchase Orders from 3 different line of business Now I'm creating a dashboard to show quarterly trends (i.e. # requisitions submitted, # of requisitions completed and total requisitions…
-
Webform Dynamic Columns
This is a question that I'm almost 100% I know the answer to, but before I give up entirely, I'll ask the question here and get the definitive answer. Is there any way to set up an update webform with dynamic columns? For instance, say I have 4 columns on a smartsheet: Name, Age, Favourite Colour, Pet, Date If I set up an…
-
Customized Dropdown LOV Per form
Hi, Can I customize the LOV of a dropdown menu in a form to be form specific? For example, on a sheet, columnX has 1,2,3,4,5,6. I want to create 2 forms, form 1 shows columnX 1,2,3 only, and form 2 shows 4,5,6, without the need to split columnX to two columns, as a workaround. Thanks! JT
-
Formula
I am attempting to sum in Summary the total amount spent on a trip by individual deapartment in this calendar year. I have the following: =SUM([TOTAL ESTIMATED COST]:[TOTAL ESTIMATED COST], Department:Department, "Trauma Healing Enterprise", [Return Date]:[Return Date], YEAR(@cell) = 2020)) I am learning as I go so this…
-
Dynamic view filter by project type
Hello everyone, Do you know if it is possible to filter on a specific column in dynamic view ? I have a sheet with a list of projects, and I would like that each project type team has only access to its projects. For example, I would like that all the users of my internal projects team can only see the list of project type…