Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for July 2016
Discussion List
Training Record
* Hi * I am wanting to create a sheet to keep track of our employee traing records. We have approximately 20 employees all with a number of training qualifications which they need to re-sit at diiferent intervals. I need to be able to list the employees with rows or columns for their qualifications where we can enter the…
Azuqua to Smartsheet
Hi I am using Azuqua Flo to copy a Row from Smartsheet-1 to Smartsheet-2. In Smartsheet-2, I have some formulas built to calculate Status, %age, Region etc. for Sight use which are 10 rows below the end of data row. Whenever a new row added to Smartsheet-1, Flo copies the row to Smartsheet-2 which is working fine but the…
How to count only Green symbols in status column
I am trying to count only the green ball symbols in my status column. I have looked around for a formula to do this and so far have some across COUNTIF(CHILDNREN) formuals. I don't have my sheet organized with children so I don't think that will work for me. I am looking for the return vaule to be a number. I have tried…
How do I provide a colleague rights to edit a webform?
Have given him admin rights to the sheet & workspace, but he still can't edit the webform. Thoughts?
Different FONT Options Within a Single Cell
Anyone found a way to bold or underline, or highlight, or change the font on certain characters within a single cell. Only way I found to highlight certain text in an individual cell is to us caps or other characters. If I try to bold, underline, highlight or change the font size it effects everything in that cell…
hide formula errors
Hello, I have WORKDAY formulas that are correct, but there is insufficient data to return a value in the formula cell so I'm getting an error. (There's no due date yet) What I would like is a way to simply hide those errors, but still have values appear when due dates are entered entered into the cells they reference to…
Number of times a sheet has been viewed / View count
Is there a way to collect or measure the number of times a sheet has been viewed? A continuously updating "Total Number of Views" for Sheet X. The data is in the system: "User Sheet Access Report" It's just impractical to download this for every shared user.
% complete is not rolling up from child to parent.
I was sent a Smartsheet project and am not sure how it was constructed. The % complete column for the child tasks have the amounts entered. The parent task does not report the calculated rollup from the children. I attempted to fix it by creating a new % completed column and entering the values by hand. When I entered the…
Can we make the web form text size bigger?
Dear all, I have been using the webform quite often right now. But the problem I have been receiving from my client is about the size of the text. I have been trying to figure out how to customize it. As I use on all device mobile, Ipad and Desktop. The Ipad is the main device I am using and I have to admit that the size…
User dashboard metrics?
Is there a way to see the metrics of how often a Smartsheet user uses the app? I have the sysadmin user report where it shows last login, but that does not identify the heavy users.