-
Loss of Tabs
Can someone please explain to me the reason for removing the sheet tabs and changing it to what we currently have now? I understand changes that are less user-friendly up front if they provide an overall better experience or increases the functionality and capabilities of a program. However, in this case I see absolutely…
-
Update Request which create a new row
Looking to have an update request that would create a new row (much like a form would do). Here is the situation: - Row with Project Name, PMs, etc... A PMs has more than 1 project. I need to calculate the weekly hours for stats purposes. If I use a form, the PM must submit it and then click back on the email again and…
-
Automatically repeat rows within a schedule (daily, weekly, monthly etc)
Hi, We use schedules to track publication output. Is there a way, when a form is completed or when a user adds to the schedule, an option can be selected to repeat the entry either daily, weekly, or monthly? Thanks, Dan
-
Reminder to complete form to outside email accounts
I have 3 forms, that I need to be sent out as a reminder on a certain date. I have a 4th form I used to collect email addresses that I would send the weekly form to those addresses. I want to keep reminding them to complete the form if they have not by a certain date. So I was thinking I could make a email list (personal)…
-
Allow access to specific items only
Hi all, I am creating a set of sheets. * Main sheet: gathers all the tickets about issues raised from the field (customer). Ticket (row) will be added using a customized form. tickets are coming from several types of users.* Engineers that belongs to the company. * Engineers that are external and belongs to the customers.…
-
Auto-Refreshing Sheets/Grids
Hello all, In m company, managers have to perform monthly audits of the plant floor. I created a system that should email them weekly notifications describing where they should be performed and who to talk to. The sheet has a week column that I'd like to automatically refresh without having to go in and manually do so. Is…
-
Flag Trigger Formula
I am trying to create a formula to trigger a red flag based on two variables: a date column and a drop down task column. Here is the formula that I have created. What syntax do I use to look for an empty cell represented here with an "X"? =IF(AND([Contact Date]1 =TODAY, [Contact Results]1 = X)
-
Sending notifications, regularly, say every Monday
I somewhat remember to read in the community that this is not supported, but want to confirm. I'd like to send a notification to people who are shared a sheet, regularly, say every Monday. How do I do it? No condition to set, simply every Monday (for example). Thanks for your advice!
-
Approvals, Updates and Deleting Attachment in a Webform during Update
HI there. I am only a month old Smartsheet user and currently under the Business Plan. i am building the New Hire Request Form for our company and I came across with problem in the multiple approval as well as the things to do before a request will be approved. When the requestor filled up the request form, it will prompt…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
