-
Cross reference error
Hi there I have created a cross reference with another sheet and named the ranges as well. It works fine for few days and then after few days it shows invalid ref error Again i have to re refere the ranges in the formula and it works fine for few days. Please help me and guide, what i have been doing wrong. Kind Regards…
-
Resetting week-1 networkdays dates based on week-2 day of the week
Hello All, I'll try and explain this without confusing everyone :) I'm building a travel calendar that project managers will fill out every Thursday for the following week. I'm using the PM's name in the parent row and dates in the child row and would like to use networkdays if possible. I don't want to create dates for…
-
Need formula to pull data from Last week Sun through Sat
The formula below is working perfectly pulling the time Laura Spent on Projects, year to date. Now the boss wants, instead of year to date, he wants to display only Dates from the previous Sun - Sat. So we want our graph to always show the data for LAST week. So no matter what day I'm looking at it THIS week. I want to see…
-
Days Duration Calculation Based on Criteria
Hi all, here's my scenario. I have four sets of cars that get moved out of my location. They come sporadically throughout the month. Im trying to figure out a formula that would average the turn time on a particular set of cars. Any ideas? Sample Below 8606 05/01/20 340200 05/02/20 8606 05/04/20 340200 05/06/20…
-
Formatting numbers like in Excel
How to format numbers in cells to show thousands separator and two decimal places. I tried to search , could not find any thread about this. Someone please help. I am new to smartsheet.
-
Yielding blank cells
Hello, I'm using health circles to indicate progress. However, I want the circles (green, red, yellow, and gray) to show active stages in the process (complete, incomplete, in progress, on hold, respectively). I want phases that are not yet started, because the start date has not yet started or is not yet set, to remain…
-
Can I hide rows using a condition?
Hello, Is there a way for me to hide rows if one of the cells says "completed" by using a conditioning format? If that is not possible, is there a formula that I can implement that would get the job done? I am managing a photography team and they have expressed the concern of seeing too much on their sheets that would…
-
Date and SUMIF or SUMIFS formula
I am needing help with the following formula. This following formula sums up by the month but I need it to sum by month AND year. For example, add up all January 2020 and then February 2020...etc. Any help is appreciated. =SUMIF({Production Credits_2020 Range 12}, MONTH(@cell) = 1, {Production Credits_2020 Range 16})
-
Automate UAT Test Script
I am looking for a way to create a test script using forms. Multiple users would complete the script which would populate a single sheet that could be reported off...... If a tester completes a step in the script (form1), they would submit/save and it would call the next step (form2), each form when complete would save to…
-
If Statement - Referencing Symbols Column and Text Column
Hello, Here's my IF Statement where I'm receiving an "Incorrect Argument Set" error. If my Active Status column (symbols) shows a blue circle, I want to return the value in Text Requested column. Otherwise display a zero value. What am I doing incorrectly? =IF([Active Status]@row, "Blue", [Total Requested]@row, "0") Thank…