-
I would like to compare week number with column name
I have a column for each work week of the year (1 to 53). I would like to append the value of HC Plan on its respective column, based on Start Week and End Week. For example, if a project starts on week 1 and end on week 2, I need to append a Head Count of 5 to the columns of Work Week 1 and 2, to keep track of HC needed…
-
Drag & Drop Emails from Outlook to Smartsheet in Chrome & Email is Deleted from Outlook
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone. I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies and uploads to Smartsheet without deleting it from Outlook. * Windows 10 Pro for…
-
Help! Multiselect Column Formula with INDEX, MATCH and HAS
Hello Smartsheet World! I am attempting to run a formula that will return contact emails depending on which departments are selected in a multi-select dropdown column. Sheet 1: Improvement Notes Smartsheet -Dept Attention column is a multi-select dropdown -Department Contacts column (in green) is a contact list that allows…
-
Tracking actual time in percentages, reporting in hours?
A component is adamant about tracking their actual time on projects based on percentage of an 8-hour workday, but senior managers want to see actuals based on hours. Is there a formula or other way for staff to enter a percentage and convert that to hours for reporting purposes?
-
Wrike/smartsheet Integration?
One of our departments made a decision to get Wrike last year. They've told me it can integrate with smartsheet- but I haven't found anything that explicitly gives how-to kind of guidance or is it just an API kind of thing where we have to pretty much develop it. I hope to show the team all the great new functionality we…
-
Annual Calendar by Day Template
Hi, We used the Annual Calendar by Day Template and it works great for the current year. However, we want to continue using the sheet in 2019 below the current year. When I copy the rows to below the current calendar, the formula is not easy to update. Row 373 holds the date the year is generated from and starting in the…
-
Formula to flag a task if not completed before due date
I'm really struggling to get the syntax right on this. I have a column called "% Complete" and a due date column called "Finish." If the % Complete < 100 and the due date is today or already passed, I want to turn on a flag in the "At Risk" column. Ideally I'd actually like to flag it if the due date is tomorrow or already…
-
Customizable Banner Messaging to Subscribers
It would be great if we could customize the banner displayed within sheets as done by Smartsheet to market new features so that SysAdmins could message to their users without the need to do by emails. Examples: Renewal survey is about to launch, Did you know you can go to our company resource dashboard by doing xxxx,…
-
UDF / User defined Fields for SysAdmins
I propose that you add a few extra fields that can be used by SysAdmins when provisioning users. There you could specify budget numbers, country of origin, etc. as needed to administer Smartsheet more easily. Today, we have to capture that data in a request form. Then, export the user list and merge with our form data to…
-
Form: Change "From" on Automated Form Submission
Hello! My team at work recently created a form with an automated email response to confirm to the recipient that their submission was received. When this email is sent, however, it reflects the name of the owner of the sheet. I am wondering if it is possible for us to change the name to something generic for our team,…
