-
Cell history and Networkdays
Hi Main issue is with the networkdays formula =NETWORKDAYS(DATEONLY([Date Submitted]@row), TODAY() - 1) Originally the formula was (thanks @Paul Newcome). =NETWORKDAYS(DATEONLY([Date Submitted]@row) + IF(AND(VALUE(MID([Date Submitted]@row, 10, FIND(":", [Date Submitted]@row) - 10)) >= 3, CONTAINS("P", [Date…
-
I need away to deal with null values in a formula.
I have a simple formula that gives a score a value. However I need an addition that checks to see if the cell is blank and if so this row should also be blank. My issue is the NULL is showing up as 0 and populating a "Low" rating. Formula: =IF([Inherent Risk Score]@row > {Key Range 3}, "High", IF([Inherent Risk Score]@row…
-
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…
-
Contact List
So I am trying to show only the person's first and last name along with their email. I have them enter their email address in the form, so is there a way to get their name in a different column so I don't have to have them enter it?
-
Is there a way to shorten the numbers? So instead of $789,137,674.05 It can be 789 and the title say
million? I'm pulling data from else where, but I'd like to shorten it so it's easier to read. Here is the formula so far: =ROUND(SUMIFS({Value}, {Sheet}, OR(@cell = "REXUS Activation", @cell = "Pending REXUS"), {Lease Exp. Date}, AND(@cell >= DATE(YEAR(TODAY()) - 2, MONTH(TODAY()), DAY(TODAY())), @cell <= TODAY())), 2)
-
Nestled IF Formula(s)
I'm sure this is simple, but I can't seem to get it. I'm trying to have the Partial Billed Dollars show in the AR column if Billed column contains a date. But once Paid column contains a date, I need that AR column to show Blank. This is done on the "child(ren)" level. I have a formula that SUMs the children. I appreciate…
-
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 we create a report on the proofing notices for a freelancer?
Hello, I have a freelancer working on some creative projects. The creative tasks are assigned under my name, and I invite the freelancer user through proofing tool for reviewing assets etc. Is there a way I can create a report for all proofing notices or assignments the freelancer user has? @Tracey Marie Harris Thank you!
-
Move Cells From a sheet to another sheet with different column names
Can you move the contents of a cell or cells from one sheet to another sheet based upon a criteria. The catch is that the columns of source sheet and destination sheet do not match.
-
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?
