-
"Something went wrong" Error
Our team continues to receive the same error message while working in our SmartSheet throughout the day. Though, when we review the SmartSheet Status page there are no similar issues listed. So, my question is: What does this "Something went wrong" mean if it keeps happening for numerous users for almost a week now? Is…
-
Trying to use Time Function to calculate how many days,hours,minutes
I am using this found in the functions list: But Error says #INVALID DATA TYPE. Is that because the columns i am referencing are cross reference formulas and not text/number types? SEE BELOW FORMULA AND SHEET: =DATEONLY([Pending Tech Response Date/Time Stamp]@row) - DATEONLY([Completed Date/Time Stamp]@row) + " day(s), " +…
-
Is it possible to filter out submissions from a form based on if the email field?
Hello, I am learning smartsheets and am unable to find a way to do this. We have a form for one of our sheets so people can submit requests to my team. However, we want the requests to only come from our organization. The form obviously has an option to only allow submissions if they have a smartsheets login but that…
-
SOC2 Result
Hi All, We are new user of Smartsheet and this community. We just like to know where we can find the SOC2 attestation result of Smartsheet to verify the operating effectiveness of the internal controls. Our IT Security is requesting for it as part of internal review. It would be very helpful if there is a link to see…
-
Calendar Date Input
We would like to double click in a square on the calendar and have it automatically pop up a box where we can input the info for that date. Having to continuously go back and forth from grid view to calendar view just slows down the process. We also would like to send an email notification or invite from the calendar to…
-
Searching for Smartsheet job FT or Contract
Hi everyone, I am a Smartsheet certified Administrator and have been using the product for over six years. Recently was laid off and looking for a role that is is more Smartsheet centered. My background is in project management and most recently scrum master/senior deliver lead. I am skilled at creating and maintaining…
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
Lookup multiple values from a dropdown cell and SUM
Hello, I am trying to populate Total Points from Sheet 1 with a formula. I would need to do a multi-value vlookup for my Sheet1[Color] and grab the related points from Sheet2[Color] and SUM them into my Sheet1[Total Points]. Is there a way to do this in Smartsheet? Please see attached images Thanks in advance
-
Hide Email Address on Webform using Contact List
I am trying to find a way on the Smartsheet web form to display the Name from the contact list, but not the email address. This is a public form, and while I want to be able to alert the event coordinator that something has been submitted, I do not want to publish the email address along with it. Thank you
-
OneNote integration in Smartsheet
Based on a suggestion I read on this board, I am posting a product enhancement request I just submitted for the community to see. Request OneNote integration in Smartsheet to easily paste in a link to a OneNote page/paragraph/section/section group in one click, and then designate whether to open in the OneNote desktop…
