-
Stars Value
How can I convert the 1-5 Stars Symbol into a number using one formula. I have one column Stars and the one with number should be Rating. I also don't know why they chose to have it convert in Excel to Empty, One, Two, Three, Four, Five. Why not numbers? Thanks for any help.
-
Column Copying
Hi, I have a need to add columns to all of my active project Smartsheets and then I need to create a webform on each of these sheets. Based on other posts I've seen, I cannot copy these columns from one Smartsheet to another so I need to manually add them, correct? Also, there is no way I can copy a webform from one sheet…
-
Generic "Forms" embedded in a sheet?
HI, I am pretty new to Smartsheet so, please forgive me if the solution to this question is obvious to most. :) Our company is developing some project management sheets to help us in our transition to paperless. We have put together a template that we feel pretty satisfied with to get going and as we start each project, we…
-
Enhancement Request: Show and allow edit of Working Days when Dependencies are disabled
When working days are set (either by SysAdmin for new sheets or directly in the sheet) and Dependencies are disabled, the dialog implies they do not impact the sheet. But they do. I posted about this today: http://ronin-global.com/2017/06/23/smartsheet-using-working-days-without-dependencies/ Since they impact the sheet,…
-
Parent Row Symbols based on highest priority?
It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows? IF the (HIGHEST) Risk Level for rows 1-4 is "x" THEN action for symbol column is "low" = blue symbol is "medium" = green symbol is "high" = yellow symbol is "extreme" = red symbol I currently have a formula to…
-
Change Column Name in Multiple Sheets
Is there a method to change column names in multiple sheets? (I'm aware of the impact on reports that include those sheets.) It is very labor-intensive to change the column names in multiple sheets, but that is how we work in the real world. Change, change, change. I've already updated the template, but wow what a pain to…
-
One Sheet with Many Projects vs. Many sheets with One Project?
We're new to Smartsheet and our web and content team are going to have multiple tasks that are going to be repeated again and again. We're going to create a checklist of steps for each one, for example, steps for creating an e-book. Since we're going to be creating lots and lots of e-books, should we create a new sheet…
-
Column Properties
How can I set up a column to capture data such as a phone number with xxx (xxx) xxxx xxxx format for Country Code, Area Code and phone number. With dafualt County Code of where there data is coming from or with a default value that can be over-wrtitten by submitter
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Cell Linking Autofill or other means when sheet too big
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…
