-
How to automatically copy the approved documents into another grid or sheet?
Hi, I have a grid or sheet where the rows which document status is already "SPC-approved" need to copy or populate to another sheet called "Approved Docs". Is there a way where this Approved-Docs sheet can automatically copy or get those rows with "SPC-approved"? Please lead me to an idea like formulas, automation…
-
Help with Sheet Summary Formulas to Create a Metric Sheet and Dashboard Chart
Hi! I'm managing a retrofit project and the end goal is to create an executive dashboard highlighting key metrics in the form of charts and/or graphs. From what I've found via searches, it seems like I need to utilize the Summary function on a sheet (my rollout schedule, in this case) in order to pull metrics the data into…
-
Limit the use of a dropdown selection to only a single row in a column
Hello, I've developed a sheet that our Project Manager use to generate a Certificate based on a number of criteria. So the Certifcate (a dashboard) pulls the correct data from multiple sources, the user needs to simply select "YES" in the appropriate row per the below screen shot. Can anyone suggest a way that limits only…
-
Send a form out daily track responses on separate row...
We have a form we would like to send to employees every morning, then be able to track each response separately. Tried automating the sending out of the form but when employees respond it overwrites the previous response because it was a "request for update". We need to track each response separately. On the same sheet…
-
How can I count dates in the past/future?
Hi, I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones are in the future and which ones are in the past. In this case, the counter should return 2 dates in the past and 1 date in…
-
Licensed user - how many workspaces can I create / share?
I'm working on developing a template workspace for our PM to use, that will eventually roll up to a PMO workspace. We plan on getting licenses for the PM if we go to production after the pilot. Each PM has multiple clients so they would have multiple workspaces. My pilot plan is to create workspaces for them and make them…
-
If Error Formula for averages
Hello, Is there a way to use IF Error for an average? So if there is no data yet, it displays zero instead of the DividebyZero error? Thanks for the assistance!
-
Remove Link but Keep the data
Hi, Is there to keep the previous data if the Reference if deleted. I have this formula =IF(vlookup(referencetoanotherSheer)=x, True). But if the other Sheet is deleted, I want it to maintain the value instead of showing #REF
-
Mirroring a Grandchild row cell in the Child row cell based off current week
Hey all, I'm relatively new to Smartsheets and am hoping someone can help me out. I promise I've looked everywhere for an answer and I think I'm making this more complicated than it is. Thanks in advance for the guidance! I have a sheet where I'm tracking historical quote metrics by Sales rep and Week. At the suggestion of…
-
COUNTIF on FLAGS at PARENTS level not returning any value (number)
Hi Smart Community, I am trying to Sum my CHILDREN() Countif but it is not giving any value. All my sub-children is indicated as flag (1 or 0) Example When there is a delay release in a category Bug Fix : it will flagged out RED. On Bug Fix, I did =COUNTIF(CHILDREN()),1)+"" This seems to work fine and return with 2 (which…