Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Calendar in Sights
Is there a way to display a calendar on a sight? I want to create a sort of home page for our department using sights and it would be great if I could add a calendar of upcoming events and have it look like a calendar. I can use a report but it won't show up in calendar view.
Show Week Numbers on the Gannt Chart
On the chart you show the months, but it would be good to have a week number listed as well. ideally week from start of year and also the option to have a week number starting at the begining (start date) of the project to see how many elapsed weeks there are.
Counting Based on Two Items
I am making a sheet to track the number of proposals we send out and how many turn into projects. I want to be able to count them by which Project Manager did it. So I have a PM field for the Project Managers initials. I was using fields for each PM's Proposals. The formula I used was COUNTIF(PM:PM, "RM") for example and…
Web Form not refreshing into worksheet
I created a worksheet to track requirements. I then created a Webform to gather this data from end users. I ran a test entry. I received email with URL to webform. I entered the data and submitted. I received a confirmation message and email. A notice appeared on the worksheet that an entry was made. I click refresh and…
Using time formula to create a master schedule
I am trying to create a sheet with a formula that calculates total time worked in a day, from a start time to an end time. I want to show who is working in specific units, from 8:30am to 7pm, at 30 minute increments for a 18 week period. See my pdf mock up attached. I created it in Excel. Any help would be a big help!…
Reminder emails
Hello all - can anyone else explain how you set reminders for every action owner on a sheet at one time? We had previously been able to do this, but now it seems you have to set individual reminders for each person, per action - which takes ages and wastes time. Any advice would be greatly appreciated, Thanks so much Ferne
Report Error
Hello, I am trying to create a report that brings in multiple date types so that I can use the calendar view to see my marketing and PR activity. I created a marketing campaign tracker and PR campaign tracker. The marketing campaign tracker has a launch date and end date and the PR tracker only had one date. I tried to…
new Notifications
i have added a new Notfication when a row is added i should get an email right away i tested a few times i added new row and saved it but i have not gotten any emails about the notfication anybody knows why ?
Automatic calculation of lag time
Hello Smartsheet community!! I hope someone can help me with the following question: I have 1 activity that depends on another BUT does not necesarly needs to start right after the predecent activity finish. I know that the duration of the activity is 2 days, and the exact date when it has to be finish. Is there any way to…
Conditional E-mail Notifications - Attachments?
I absolutely love the new Conditional Notification feature from Smartsheet. Thank you so much! I do however, wish that you could view the attachments in the e-mail. This was part of an existing issue we had with some of the automated e-mails we set up before (either through other companies or via notifications) If there is…
