Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
Count If and Not blankIn Formulas and FunctionsHey everyone, I am trying to count cells in a column where one column is not blank and cells in the other column matches a certain criteria. The columns are: Responsible Department - I want to count the cells in this column that are not b…
-
Workflow for adding a record from a formIn Formulas and FunctionsMy sheet has a form where people request a service. Filling out the form creates a record in my sheet. I also have a workflow that sends the requestor an email confirmation, with the details of the request, when a new record is added to …
-
Automated Workflow Execution TimeIn Formulas and FunctionsI have created several automated workflows, which should be initiating as soon as something changes in the sheets, however to get it to work I am having to save and refresh my page every time. Have I made a mistake when creating the workfl…
-
Counting tasks throughout the yearIn Formulas and FunctionsHi, I'm counting how many times certain tasks has been added to the list of TO DO of the year, Meaning for instance if one of my teams (there are 4) has added to the list of day1, task1, and task2 (a different color for every task). My pro…
-
Record changes to only 1 cellIn Formulas and FunctionsIn a sheet where another user and I download files and mark them in different stages (proofed, processed, uploaded), is there a way to record who last modified a cell rather than a whole row? I'd like to have a cell automatically record wh…
-
how does the formula work for duration column when predecessor activatedIn Formulas and FunctionsI am getting a #invalide data type in some but not all rows.
-
IF/AND cross-sheet formula not workingIn Formulas and FunctionsHi all, I'm trying to create a column formula but only select one date out of 2 available. Current layout of my sheet is as below: What I'm trying to teach to the system is that if Global lead is not equal to X and Regional Start-Up Date (…
-
Dashboard, column cutIn Formulas and FunctionsDear all I have created this Dashboard from a report and on the first column (see picture) value/text is not shown completely - actually it should say LAUFEN. This BRAND column is not the primary column and the Align cell function is also …
-
Hyperlink functionIn Formulas and FunctionsBased on community articles, I am confused if the Hyperlink function exists or not. Regardless, here is what I am trying to accomplish. In the roadmap tracking sheet, I have a column "Assigned Team". Each team has a workspace wi…
-
Counting Instances Across SheetsIn Formulas and FunctionsI am building a dashboard for each of the colleges at my university. I originally created a Smartsheet for each college that lists all of the courses in each of the programs in the college, documenting whether or not we have a course maste…
