-
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…
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
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…
-
Checked and unchecked box
I need the amount from 1 column to appear in another column if the box between both columns are checked. Please write out the formula so I can copy and paste. Please see the attachment. Greatly appreciated.
-
RYG automation based on percentage
I am hoping to get a formula to work for me- I have read a million boards and non of them work for me! What I am looking to do. If percent >=100, red circle If percent >= 50 and <100 yellow circle If percent <50, green circle this is the formula I am currently using; =IF([Percent of budget spent]2 >= 100, "Red",…
-
INDEX and MATCH #invalid value error
Hi! I'm trying to apply a formula we got to work in Excel to our Smartsheet. The goal is to look at a range (Column "1" through Column "Column64") in a single row and find the non-blank cell farthest to the right and return the value from the same column in row 2. (Row 2 was created to replicate the name of the column…
-
System Field: Date/TimeStamp behaviour
Hi all, Have been a fan and avid user of SmartSheet since 2015. Great to see all the continual roll out of new capabilities / functionality. I am currently working on building a triggered notification on SmartSheet -- essentially, if a specific row has not been updated for "x" days, it will fire a notification to a…