-
Formulas in Workspaces
A few questions: I recently transferred over some sheets to a workspace area and when I did, it appears that it cleared out any formulas or automation from those sheets. Is that how it should work? Did I not transfer it correctly? Since all my formulas are now gone, i've manually tried a few times to enter the formula that…
-
Using IF, FUNCTIONS (HAS, CONTAINS, etc.), and OR (for searched fields).
Greetings Team, I feel like I'm missing something simple on this one, but it's a general problem that I encounter a lot. For this question, I'm able to construct formulas that Smartsheet accepts, but the current version is long and more difficult to understand/manage from other users. This involves using IF, FUNCTIONS, and…
-
Can JOIN include a space as part of the end result?
After JOINing a series of cells, I need to include a space after "CSANe" but it keeps getting ignored. Certificate No. column is the JOINed result Cert # Preface is a formula. I tried ="CSANe " I tried adding the Spacer column with the formula =" " The space is always ignored. Is there any way to get the space to appear?
-
Check a box in Parent cell based on children cells
Hello, I need to check a box in a parent cell only when all children cells in that column have been checked. I will manually paste this formula into multiple parent cells in my sheet. The formula I tried did not work...Any guidance or tips on where I went wrong? My thought was if I gave the range of children cells, and…
-
Count if for multiple columns
Hi all, I'm trying to create a count if formula to find data in two columns. For instance I have two columns. One column is status and the other is for discipline. I am trying to count if the status is "complete" and the discipline is "marketing". I need the formula to tell me what is the total count in the Smartsheet.…
-
Formula help - Countifs, contains, and adding an OR function
Hi Smartsheet Experts: I am working on a formula and have gotten stuck. I have a countifs formula, and I need to change it to count customers with either Product A or Product B (some have both) - I can't figure out how to insert an "OR" function into the formula without breaking it. Right now the formula is actually…
-
Weird outcome with Large function
I am experiencing a weird scenario while trying to use the Large function. What I want to do is to get the two most recent dates from a column with numerous dates. Please check the sample datasheet: The Dates column contains the dates and I am showing the two most recent dates in the column Recent Dates. I am using the…
-
@column alternative / is there an @column function?
Hi everyone, I've created a formula that I'd like to replicate over many columns. I know I can paste it and change the column number, but is there a way to instruct the formula use a numbered row (in this case, 20) and the current column? Something like @column =COUNTIFS({April/May 2021 Boot Raw Data Range 1}, [Primary…
-
Percentage of a number within a cell
In Excel, I can utilize the following formula to find the percentage of a number. Input =H5*30.1% Output $11,371.11 When H5=$37,777.78 However, in Smartsheet, the formula does not copy over and when the formula is manually entered in Smartsheet, it tells me that it is unparseable. Manually doing the calculation defeats the…
-
Countifs Formula where one value may be a fragment or a word (but I only want it counted as word)
Hello, I've written a countifs formula for the number of times certain words show up in a column on another sheet based on a date column in that sheet. The formula works fine for most words such as "Recruitment" or "Compliance". However, I have one value that is "NCE" and that's where I'm having the problem. I need to…