Formulas and Functions
Archives for January 2021
Discussion List
-
Error with COUNTIFs and date formulaIn Formulas and FunctionsHello! Can someone please advise what am I doing wrong getting this error? The formula used is as follows: =COUNTIFS({ref sheet}, AND(MONTH(@cell) = 1, YEAR(@cell) = 2021)) The date column in the reference sheet is set as "Date"…
-
Index Match IssueIn Formulas and FunctionsHello, I seem to be having an Index Match formula issue that I cannot figure out. I've used this formula many times and never had an issue. The screenshots attached should explain fully what is going on. For some reason, it seems to be…Answered - Pending Review 6 views 2 comments 0 points Most recent by Devon Eddy Formulas and Functions
-
RemindersIn Formulas and FunctionsIf a column status shows as Submitted from another column for the approver, is a reminder able to be set via the automation set up?Answered - Pending Review 7 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
IF formula from multiple cell informationIn Formulas and FunctionsI've been tasked to show the approval status of a row. Due to how I created the automation, depending on the level of an award (same sheet as referred to recently) the Manager signer may show status in 1 of 3 different columns. I want to …Answered - Pending Review 7 views 1 comment 0 points Most recent by Bassam.M Khalil Formulas and Functions
-
JOIN(DISTINCT(COLLECT())) without losing Contact List column functionalityIn Formulas and FunctionsHowdy - is there a formulaic way to gather all contact list column values alongside DISTINCT(COLLECT())? JOIN eliminates the contact list returns, converting them to strings, and trying something more convoluted via the Name + "<&q…
-
Cloning Automated Workflows Across SheetsIn Formulas and FunctionsIs there any way to clone/ copy an automated workflow from one sheet to multiple other sheets without having to recreate it manually in each sheet?Answered - Pending Review 10 views 2 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Can you copy / export workflows, conditional formatting and saved filters to other worksheetIn Formulas and FunctionsWe stated using Smartsheet back in November and I have a few active Smartsheet for projects and more we use it the more I find things I want to do across all sheets. If I add a workflow, conditional formation or saved filters to a sheet is…Answered - Pending Review 9 views 2 comments 1 point Most recent by Andrée Starå Formulas and Functions
-
COUNTIFS function showing errorIn Formulas and FunctionsI am counting the nos. of specific activity within the specific month. (Two different columns) Want this formula in the summary sheet. tried several ways but didn't get the desired results. I tried =COUNTIFS([Activity Type]:[Activity Type]…
-
Changing the format of a the Created (Date)In Formulas and FunctionsI wanted to have a date when a task was added so I am using the Create (Date) under system-generated column. "See Below" but I only want to display the date not the time. I was looking away to format the cell so it would show onl…
-
More than one rangeIn Formulas and FunctionsHi gurus! I am having trouble with multiple SUMIFS. I have tried nesting them, but there must be an easier way. I need to sum the cells in the GW and CGW columns when people manager=yes. Can anyone help? I feel like the answer is right…