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.
Archived 2016 Posts
Archives for June 2016
Discussion List
Need help with reports and designing my sheet
Hi - I'd like to take advantage of the 30 min session to help design our smartsheet. I'm running into some roadblocks with how it's currently set up and creating reports based on when projects are live. Can somebody please contact me?
Decision matrix template?
Hi all, I am new to smartsheet, and have created a decision matrix style spreadsheet to compare special schools for my son, giving ratings according to different criteria. I want to then be able to work out. Instead of stumbling along to work it out, I assume someone will have something suitable? If not sure what I am…
Moved: Nested If Formula
This discussion has been moved.
New Row notifications via Send option
I want to use the "Send" option to send an email to the user each time a new row is entered, automatically. I have used the Notication Alert but it accumulates the rows in the same email.
If And Formula Help
Greetings! I am new to the forum so I apologize if my question is redundant! I am trying to combine two "If" statements into a single formula. I need smartsheet to look at two columns (Due Date) and (Project Completed -- checkbox) and determine if a project is late. I can get each half of the formula to work individually,…
Create birthday calendar with reminders - no year entry
We would like to use SS to create an employee birthday calendar and set the due date as their birthday - without using the birth year (so we don't have to recreate the wheel in subsequent years). If I set the birthday (date) column, I have no option but to use the current year. OR, once the sheet is set up, is there a way…
Manage project by workload instead of duration
Hello all, in our company we used to work by workload instead of duration / capacity. This is really important for us as we're a consultancy company and selling man days and not duration. What is the best way to work like that ? For the moment the workaround is: - I use is to put a duration then calculate the allocation %…
Scheduled email based on a condition - Request
First off, having scheduled email across the entire platform would be a godsend on its own. Such as from a report. This way i can have only the information i want them to see is sent. Secondly, sending an email based on a condition. Basic example, if a box is check, send the email at such dy and time. Is there a better or…
Tracking articles
Does anyone have a template that works to track professional articles, books, etc. along with notes as you would find in a bibliography?
API Report restricted to first page
We wish to download through url access a report that is 850 rows so expands over 2 pages. When we access it we only get the first page. Is there a way to get all pages? Below is our curl code (the XXXXX.... is our authorization which we have masked):…