(Beginner) Changing column properties for specific rows

ArthurC

I am tracking staff training and have dates for when staff are scheduled for training and have columns as date format.

 

at the top or bottom of the sheet, i would like to do a count of total staff scheduled or completed for that column, however, because i've set the column as date, it changes any numbers i input to as a date.

is there a way to change the properties of specific cells/rows?

Paul Newcome

Unfortunately column types are for the entire column. You cannot change the type for a specific cell or row. Feel free to submit a product enhancement request though.

 

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?_ga=2.219033945.1514116697.1560166165-1781996719.1558354772

 

However... Converting the numerical value to text will allow that number to be displayed. It would just have to be converted back to a numerical value using a VALUE function before it can be used as a number in other calculations.

 

To convert a number (for example 42) from a numerical value to a text string, you could do it one of two ways.

1. Either add + "" (plus double quotes) to the end of the number You can also put this at the end of a formula if that formula is generating a number):

 

=42 + ""

 

2. Or you can just wrap the number itself in quotes (this works ONLY for manually entered numbers/you would have to use method 1 if a formula is involved):

 

="42"