-
Sum Values Between Two Dates
I'm looking for some help with a formula. I've created a complicated system of sheets where a contractor enters her/his hours into a form each day they work and I link the data into a contractor's individual sheets which then feed into a series of formulas which feed into reports which feed into sights. What I need to doā¦
-
Interactive Forms
I would like to create a form to collect a variety of information from users. For example, we want to record publications, presentations, and proposals that a faculty member has done in the past month. However, I'd like to keep the form short. If a faculty member has had 2 publications, but 0 presentations and 0 proposals,ā¦
-
SysAdmin
Good Afternoon, We use Smartsheets rather extensively. Our SysAdmin has since left our company and I need to assign a new SysAdmin to our account. How do I go about doing this? Thanks
-
Sending notifications to a contact list; user not shared to sheet
Hello! I have a sheet where there is a "Contact List" column and I want to send a notifications to that contact, but they are not shared to the sheet. The contacts are not receiving the notifications currently and I'm not sure why. I thought this was an upgrade Smartsheet made recently, but maybe I'm wrong. Thoughts?Ā
-
How do I change a user's login name
What is the correct process for changing a user's login name after they have a name change (marriage, incorrect spelling when created, etc) I see I can change the first name / last name, but I'm not able to find out how to change the login / email address.
-
Help
I inserted a row at the bottom of Product Development and the End Date did not change at the top level of the cycle. My cycle ends on 12/27/17 and the End Date shows 11/27/17. I tried to edit formula but cannot. Example file attached
-
If cell fill is a given hex color code, then return value
How can I identify the hex color code for the cell fill options? I want to write an IF statement to returnĀ value of 1Ā if the hex color code is the darkest blue (as an example). A little background.... reporting 6Ā status stages so the symbols aren't an option. Thanks in advance for your help!
-
SUMIFS Formula
We currently have a SUMIF formula that sums up a Annualized Estimate for a specific Ministry. The Sheet with this data uses a form to populate additional rows. The currently working formula isĀ =SUMIF(Ministry:Ministry, [Ministry Name - Annualized Estimate], [Annualized Estimate]:[Annualized Estimate]) We wanted to breakā¦
-
How to count the number of rows of the children?
Hi guys, I spent a whole day searching the forum but didn't find any relevant answer. I need to know how many children rows a parent have to do some calculation. So it's not about the content/number/text in any cell of the children rows, but the NUMBER OF CHILDREN ROWS(no matter what's inside them, even if they are blank).ā¦
-
Outlook Integration - Updating Comments sent out as emails
I currently use the Smartsheet Add-In for Outlook for forward relevant emails to existing (or creating new) tasks and this works well in tracking needed information. I currently use Smartsheet individually and not as part of a team or group. I am wondering if there is a way I canĀ add a comment to a Smartsheet task/rowā¦