-
SUMIFS formula returning #INCORRECT ARGUMENT SET: order of Range & Criteria?
Hello, I cannot figure out why this SUMIFS is not working. When I break up the SUMIF criteria, they both work fine. But when I put them together, I get #INCORRECT ARGUMENT SET error message. =SUMIFS({MH Client Profiles v2 Range 13}, "East", {MH Client Profiles v2 Range 16}, 1, {MH Client Profiles v2 Range 3}) All I want is…
-
Smartsheet for Pandemic Readiness- Dont Panic Prepare!
IT departments must take the lead on pandemic response planning... Your Challenge COVID-19 still has a lot of unknowns. Despite efforts by international and regional health authorities, misinformation and misinterpretation of available information are complicating the situation as individuals and organizations seek to…
-
Private Comments
I am trying to figure out if there is a way to make a Private Comment in Smartsheet? Let's say I have a Published Report that is viewable to anyone with the link; however, I want to make a comment on a line that I don't want anyone to be able to view outside of the original document. How can I do this?
-
At Risk Flag Formula issues/questions
I searched through the Community and found a couple of formulae that either directly addressed what I want to accomplish or I thought could be modifed to do what I want. I get the #UNPARSEABLE error for each of them. I'm sure I'm missing something basic (new user) since all of the responses to the solutions are positive. I…
-
Jira Plug-in IT Support
How do I get someone from Smartsheet IT support to contact me? I received a trial version of the Jira plug-in but having issues get it connected and have been trying to contact support for 2 weeks now. I've created a support ticket, emailed my sales representative, and left a voicemail. Kind of getting frustrated with the…
-
How to add multiple values when creating a chart/graph?
How I can pull data from a cell with multiple values to create charts/graphs? Currently, the graph only shows/captures single value from the cell and not the other one. Is there a way around how to get this done? For example, when i am trying to build a bar graph for the values under "Hiring Manager" on row 5 -the second…
-
How can i tell if an email in outlook was sent to Smartsheet?
I use The Smartsheet for Outlook Add-in frequently and it is a great tool for uploading email conversations and attachments, however there are instances where I'm not sure if I have already attached an email. Is there a flag of some sort that can indicate if an email has been added to Smartsheet, and if so where it was…
-
IF(ISBLANK with IF work on one Column but not the other
Hello, I was looking all over the Community page and I was able to find the help I needed to make my statement work but when I changed the column in the statement it would stop working. I was hoping someone could explain the difference to me. Below are my examples. 1. Working statement =IF(ISBLANK(task@row), "Not Started",…
-
Field Rules on Forms
Hello, Will smartsheet look to implement field rules on the forms? For example: Show field: New employee email When field: employee type: New Employee is selected It would be very helpful to show or hide fields on the forms. Thanks Quisha
-
Locking or freezing the TODAY() formula
Good day all, I've looked around in the community about locking or freezing a current date, but I'm still having issues. My goal is to lock a start date that's triggered by entering a X and have that current date freeze until the x is removed. When an X is entered in the Visit column, that triggers a start date to…
