-
Report Publishing...
I want to be able to publish a report link for editors to update a project status the way I can publish fully editable links via the sheet itself. Why can I only publish secure links for reports that require a login? I want editors to have access to change information in a report without logging in. What am I missing?
-
How to Format Alert/Actions Subject Line in Templates
Hi, I've created a project schedule template that I will use for multiple projects throughout the year (avg. 100). This template has a total of 4 different alerts/actions. The template will default to a subject line like this one for a notification: - "Changes to Schedule #1: Project w/Professional Print2: Notification"…
-
Automatically add emails into smartsheet
Is it possible for an email to automatically be added into a smartsheet? Just like a form entry gets added, can someone send an email to a particular email address that is automatically added to a smartsheet? I saw an old post about this from a few years ago but want to know if this is something that can be done now. It…
-
INDEX/MATCH not working
Below are two screenshots. The first is a screenshot of my target sheet. The other is a screenshot of my reference sheet. On the reference sheet I have a list along the left. In the column to the right is: =TODAY() On the target sheet is an identical list with the following formula to the right: =IF(TODAY() = INDEX({New…
-
SmartSheet meeting Tracker
I am looking to see if someone knows of any templates for a meeting tracker. Basically what it would do is we would have a Directors meeting. it would track all the attendes. From that Directors meeting we would set a deadline for those Directors to have a Departmental meeting. We would also keep notes of some thing within…
-
Countdown from today not working
I am having the hardest time using any kind of formula...whenever I type them in I get the unparsed error. I am trying to do a countdown from today to an end date but no dice. I find the explanations on here for how functions work aren't really helpful for me. I have turned on and off the duration function, it gave me a…
-
Doing by date and not by task
We are a Habitat for Humanity affiliate. We do a group of different tasks on each day we build. Can I have a task for the days such as Day One, Day Two, Day Three and so on and make that the predecessor for the different tasks done on that day. If not how do I do it.
-
Summing children rows without double counting parents
Hello friends- I am creating a spreadsheet to help track project financials for a specific grant that the non-profit which I work for received. Specifically in the Summary Table, I have a sumifs formula which grabs specific line items based on the date and which installment of the grant they are using. I believe that the…
-
Few questions about Smartsheet
Hello, I'm new to Smartsheet and created a trial account to test if we can automate our resource management process with it. I have the following questions about Smartsheet. 1. With Alerts & Notifications I want to create rules to send notifications or approvals to project managers, team managers and project members. Is it…
-
Company uses smart sheet in metro manila philippines
Hi is there any company here uses smartsheet in philippines specially in metro manila? may i know the company name thank you