Discussion List
Column Headers & Color
This discussion was created from comments split from: Welcome to the online Smartsheet Community!.
Smartsheet contacts - Deleting Contacts
Is there a master list somewhere where these are stored? I deleted contacts from my personal contacts list but some contacts are still appearing as selectable on my smartsheets. What am I missing?
I need the Form to populate information to different sheets in Smartsheet
Hello Smartsheet community, Could you please advice, I need the Form to populate information to different sheets in Smartsheet depending on the dropdown menu choice. For example, there is a new project enquiry form, depending on the department choice information should be populated to the appropriate department's sheet. I…
Sheet Summary % Complete
I am feeling silly that I can't get this to work. I want to get the % complete of my project based on those with the status of "Complete" divided by all columns that have text in it. =COUNTIF(Status:Status, "Complete") / COUNTIF(Status:Status, ISTEXT(@cell))
Health ball question
I tried to search how to do this formula, and I feel like I'm really close, however it just isn't right. I am looking to write a formula where it will show the "health" of an error percentage. 0% is green; 1<50% is yellow; 50%< is red Where 0% is green; 1-50% is yellow and over 50% is red. Thank you!
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
Smartsheet API Documentation unexpectedly asking for login (23 Apr)
I'm unable to log into the smart sheet API Documentation. Till yesterday I was able to access the API documentation did not prompt for login. Kindly help me log in to SmartSheet Official API and SDK Documentation Log in with Redocly
zip Code Radius Help
Hello Everyone!!! Hope my question makes sense. But I am trying to figure out if there is a formula that can provide me a Max Distance radius from Retailer formula that shows the max range in which we should set our radius targeting for these retailers. I have the retailers full address, Zip, Lat and Long so I feel like…
Track approvals missing when multilple stakeholders are required to approve on workflow
Is there a way to track who has approved and who is pending to approve an approval request from a workflow? Thanks in advance.
Row automation - add to top of sheet
Add an option when using automation to move/copy a row to add the row to the top of the sheet.