-
Referencing % in Formula in Symbol Column (RYG)
Is there a trick to referencing % Percentages)when using the If function, automating the RYG symbols in a Symbol column? I have a simple IF formula referencing cell formatted to %. When I replace the % with any text and update formula to reflect the change, the correct RYG symbol is displayed. When I attempt to reference…
-
Conditional formatting for all children?
Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. So for example, let's say "Phase 1" of a project is the parent, we would like an easy way to have the…
-
COUNTIFS returning #INCORRECT ARGUMENT SET
Hi all - I cannot figure out what's going wrong here. I'm trying to count rows in another sheet ("Sheet A") where both the following are true: * Done = 0 * IsChild = 0 My formula is: * =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0) Now this works perfectly! So in a cell right below that one, I then try to count rows…
-
Help converting and excel formula to smartsheet
Hi everyone, I'm pretty new to smartsheet so I may be asking your help for something that is quite easy to do :) I have an excel formula that I need to migrate to smartsheet to help me transform seconds in HH:MM:SS The excel formula is =TEXT(IF(I4="";50;I4)/(24*60*60);"hh:mm:ss") & ":00" Is there a way to use the same…
-
Allocation in Template Sets
Good morning. I joined the webinar yesterday regarding Template Sets and we've already begun creating a sheet for our projects using one of these template sets. Great job Smartsheet!!! We love the compatibility you have created with Project and this will definitely benefit us in the very near future. I did notice, however,…
-
Creating a Task Tracker for Multiple Leaders
I manage a large group of leaders and locations who all are completing similar tasks throughout the month and I am looking to track progress without going back and forth via email. I have created a task list for each location as the parent and each specific task as sub-tasks and then assigned them to each leader. When I…
-
IF Statements and Linking Sheets by Ranges
Hi, I am working on a project creating a weekly sheet for distribution where one week of info is pulled from a range of data on a separate 13-week sheet. Basically, on the weekly sheet, I am using IF() statements to search a cell on the 13-week sheet for text. If the cell contains the proper text, the name from that row on…
-
Moving Rows to other sheets for non-Admin users
We have a non-admin user that would like to be able to archive her own rows to another sheet. She thought she used to have those capabilities but brought it to my attention that she no longer has them. Is there a way that a non admin user can move rows to another sheet?
-
Use a form to lookup sheet data that and add content to it
Hello, I have read the forms with the “VLOOKUP” and “LOOKUP” functions. I am new to smart sheet, but not to excel formulas. I have an associate inspecting carts for wear and tear items, this is working well with check boxes and the photo attachment is awesome to have. Next step is the associate that repairs the cart, I…
-
Setting up a sheet for KPI's dates in row vs columns
I`m setting up dashboards which will be cascading with roll ups to the executive level. These are operations related data and not project related. In setting up the sheets I had looked at some of the templates and seen that very often they are set up with the dates of the entries running along the top of the sheet heading…
