-
¿Cómo le ha ayudado Smartsheet a avanzar en su carrera?
Hola, Comunidad: Vuelven las SmartStories, destacando las voces de la Comunidad. En esta ocasión, los miembros comparten cómo Smartsheet les ha ayudado a avanzar en sus carreras profesionales. Vean el vídeo a continuación e inspírense con sus historias de éxito. Un saludo a los miembros de la Comunidad que aparecen en esta…
-
I need to move a folder and all of it's contents from one workspace to another. How?
-
Hidden Columns List
I would love to have a collapsable/expandable list of all hidden columns on a sheet with the option to unhide them from the list. This way, if I have multiple hidden columns and I just want one or two of them, I don't have to unhide everything to get to them. This would also allow you to look for columns that might be…
-
Formula countif
Hallo Can you check what i need to do to change the formula . Example When i use formul =COUNTIF([Column2]:[Column2]; [Column2]@row) Then when cell in location is emty ( which is always empty ) then it is i always get total numer of cels … Can someone help me to make formul to make sure this doesnt count emty field into…
-
Formule
I have a general list with all data in In that list i have a column Location Those cells are filled in when we scan a location. i want to make a new sheet inside smartsheet where i can see which location are still free. So i uploaded all the location numbers in a column , this column needs to be cross checked with the data…
-
NETWORKDAY Not Working With Columns With Formula
Hello :) I'm calculating the difference between Bethany's Start Date and Bethany's Updated Start Date. The "Bethany's Updated Start Date" column has a formula. When I use NETWORKDAY, it returns an invalid value and I think this is because the "Bethany's Updated Start Date" has a formula in it. I tried wrapping the formula…
-
Cell-level Comments
Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads "Cell" next to the "Row," "Sheet," and "All" tabs. Currently, I'm spending a lot of time describing columns and going back and forth on communication to confirm columns and which…
-
Feature idea: Improve clean out multiple contacts in "column properties" dropdown list
Hi there, My company would like me to clean out the retired emails (contacts). There are almost 500 contacts in the column and I need to clean out about 60 contacts. However, I can't search and delete because it won't allow me to delete after searching. I need to go over the dropdown list one by one to look for the…
-
Colored Dots Formula
I'm trying to use a formula to populate a column with colored dots based off of a date. This is what I'm trying to do Red - Date prior to TODAY Yellow - Date within the next 90 days from TODAY Green - Date greater than 90 days from TODAY Gray - Date is blank I keep getting the unparseable error. This is my formula:…
-
How to clean out multiple contacts in "column properties" dropdown list
Hi there, I am quite new to Smartsheet and recently my company would like me to clean out the retired emails (contacts). There are almost 500 contacts in the column and I need to clean out about 60 contacts. Is there a way that I can search and delete? They are random and I tried to search in "Column properties" but it…
