Formulas and Functions
Archives for February 2021
Discussion List
-
Help with Formulas in Summary SheetsIn Formulas and FunctionsI am new to formulas and need help with a COUNTIFS formula. I am trying to quantify how many RAID Log items are in a sheet and I tried several combinations but can't seem to find the appropriate formula. See below, what would be the approp…Answered - Pending Review 7 views 2 comments 0 points Most recent by Silvana Luna Formulas and Functions
-
Date range in formulaIn Formulas and FunctionsHello! I am trying to write a formula to pick up statuses before a specific date. So I want everthing before 4/1/2021, but nothing after. Here is what I have (I tried to look at others on the message board) but it still isn't correct. …Answered - Pending Review 8 views 1 comment 0 points Most recent by Mike Wilday Formulas and Functions
-
Can you use Ancestors along with IF(And to check a box?In Formulas and FunctionsHello, I need some help with a formula, if it is even possible. Scenario: Overall Project: checkbox column Exec Report Activity: checkbox column Reporting: checkbox column Is it possible to have a formula search for a checked box in the O…
-
Percentage CompleteIn Formulas and FunctionsGood afternoon, I am hoping for some guidance on how to set up a percentage complete column to track progress for a specific set of tasks. Thank you, Corey Niro 512-214-2527Answered - Pending Review 6 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
can we do this?In Formulas and FunctionsI have a smartsheet that I would like the following steps to take place automatically. I have the following columns Percent Complete column which has symbols in it. Resolved column which is a check mark. Completed column that is a date. I…Answered - Pending Review 8 views 2 comments 0 points Most recent by maynardg Formulas and Functions
-
Display Calls Made TodayIn Formulas and FunctionsI want to do something simple but can't seem to figure it out. In a summary, I want to display the number of "Calls Made" for the current date. In other words, I want to display the number entered in the "Calls Made"…
-
No luck color coding headings for various row levelsIn Formulas and FunctionsHi, Once you select "dependencies" on a sheet, it says that the top level rows are supposed to be shaded in grey. This is not happening for me. I also wanted to conditionally format so that various levels have a particular backg…Answered - Pending Review 13 views 4 comments 0 points Most recent by Mary Vogt Formulas and Functions
-
Referring ReportsIn Formulas and FunctionsHi Team, I was trying to create summary sheet by doing a reference to a report which is a consolidation of multiple sheets. I don't see reports when looking to reference. Is it not allowed? Is there any work around? Kindly suggest.Answered - Pending Review 8 views 2 comments 0 points Most recent by Shubhashish Sarkar Formulas and Functions
-
Update Sheet 1, Based on Submission to Sheet 2In Formulas and FunctionsI have a quick question. I have 2 sheets (Sheet 1 and Sheet 2). In Sheet 2, users submit a form and a field (which is hidden) is automatically checked indicating it's been submitted. What I'm wanting to do is - essentially - notify Sheet 1…
-
Look up Function - Multiple MatchesIn Formulas and FunctionsI'm having trouble coming up with the correct function and am hopping someone can help. I have Sheet A that contains the data show in screenshot below. I also have a Sheet B, where I am trying to pull data from Sheet A, when I reference …
