-
UPDATE to previous question
Using Excel - it is possible to place an "=" sign in a cell and then go to another sheet and click on another cell and hit enter and it "links" the 2 cells together so that if the number in one cell is changed - it changes it on the other sheet too. Question: is it possible to do this with Smartsheets?
-
How do you filter for a specific word w/o it pulling in things that contain the same letters?
I've created a report to pull only tasks that contain the word COA, but it's also pulling in tasks that just contain that series of letters such as "coating", is there a way to make it clear it is exact word only in the filter or other trick?
-
Cell Formula For Traffic Light Symbols
Hello, see attached screenshot. in the yellow cell (top right) I am wanting to have a SUM of the below 'Days To Complete' cells, but only those that have the Green traffic lights. As you can see this is a team members project list, so we are trying to estimate the work ahead for this team member. Can someone please help…
-
Workflow not working
Hello, I have a sheet that formulates each person's hire date anniversary and birth date anniversary. I have a workflow to notify specific users the day before each. However it has not been working and I cannot figure out why. The only thing I can think of is that each column has a column formula to determine the correct…
-
COUNTIF = BOOLEAN EXPECTED
Hi I want my smartsheet to count the number of checked boxes in a specific column. I have formulated: =COUNTIFS([Ceremony/Party]:[Ceremony/Party], 1). However, it is cominh up with "BOOLEAN EXPECTED"?
-
Schedule Delta %
Hi, I encounter "#Unpaseable" error code on the "Schedule Delta (%) formula with a number of attempts. Tried following the example shown in the Smartsheet's PMO template example as well as make slight change to correct a possible typo on Syntax in the Smartsheet example. See attached doc that captures the screenshots of…
-
COUNTIF:CONTAINS formula help
Hello! I'm working on a formula to capture project start dates in each month. The formula I'm using is as follows: =COUNTIFS({Target Start Date}, (CONTAINS("January", @cell)), {Status}, ="In Progress", {Type}, ="Enterprise") I'm not getting an error message with this formula but it doesn't appear to be capturing any of the…
-
Formulla to generate met, not met, partially met and N/A
Hello, Can any one help? I need a formulla to generate the % "Met", "Not Met", "Partially Met" and "N/A" which is provided in a spreadsheet on a monthly basis. So I will have one spreadsheet with the incoming data. The formulla generates "# Divisible by zero (see attached): I am using the following formulla:…
-
Countifs forumla with 3 criteria's
I'm have used a countifs formula to count the total number of jobs per month that have been launched in my business using the following formula: =COUNTIFS({Project Launch Input 2021+ Range 3}, >=DATE(2022, 6, 1), {Project Launch Input 2021+ Range 3}, <=DATE(2022, 6, 31)) I now what to be able to count the number of jobs…
-
Join Formula from Reference Sheet
I am trying to use Join Formula to concatenate 2 adjacent cells from different columns of another sheet. It returns the value correctly actually, however, as I am trying to drag the formula down, it doesn't work anymore unless I specifically edit again the formula in each cell which is impractical as I have more than a…