-
Forumula for trending up/down
Hello, I need a formula to display the trend of a number. As rows (data) comes in the average value of the column changes and as time goes by the values will go down. I need to compare that average value each day. Meaning if today's average is 5.10 and tomorrows average is 5.50, I need to compare those two numbers to…
-
How to ignore, or return a 0 with a blank cell in an IF formula
Hello! I'm trying to calculate my savings year-to-date. I thought i had the formula, but soon realized that having blank dates (maybe we don't have a start selling date, or the project is still in development), it'll still return a value when it should really be $0. I have no doubt there is a more elegant way to do my…
-
Tracking rows from other sheets
Hi everybody I have several rows from different sheets that feed my master sheet via "move row" automation. I need to track in a column on my master sheet which row is coming from which sheet. The only approach I can think of is adding a column on each sheet with its name so when the row is moved, it is added to the master…
-
What is the effective approach to Group Management and Contacts
i would like to have a contact with name. I need Groups so have to add contacts via Group Management else it won't allow me to add a contact from "My Smartsheet Contacts" Within Groups, I can either paste all emails or add one by one. The former will not allow names to be added, the latter is manual and painstaking if I…
-
Counting multi select column that is also contact list
I have Contact list - multiple resources can be assigned task I want to count the number of times a particular resource has been assigned a task. I've tried these both: =COUNTIF({Staff Actions Range 4}, HAS("Joe X", {Staff Actions Range 4})) =COUNTIF({Staff Actions Range 4}, CONTAINS("Joe X", {Staff Actions Range 4})) Both…
-
Smartsheet for Pandemic Readiness- Dont Panic Prepare!
IT departments must take the lead on pandemic response planning... Your Challenge COVID-19 still has a lot of unknowns. Despite efforts by international and regional health authorities, misinformation and misinterpretation of available information are complicating the situation as individuals and organizations seek to…
-
Report from multiple sheets - but automatically including new sheets
We have three basic templates we may use to create a new WorkSpace. Each new WorkSpace represents a project and will have a sheet called "Transition Tracker". I'd like to run a report of information from each sheet in each WorkSpace (so across sheets), but also have it add new sheets as new Workspaces are created. Is that…
-
Combining Two Formulas in One Cell (NETDAYS and Addition)
Hi everyone, I am looking to combine two formulas in one cell (one to calculate number of days; one to calculate completion date, using calculated days). The information below was provided to me by my supervisor to use, but I have been struggling to come up with a solution. Here is the information: Formula: First Product…
-
How to change status based on start/end dates/if completed was checked or not.
Hi there, I've been reviewing past topics but haven't been able to get those formulas to work. I have a sheet where there are start/end dates, and a completed check box column. I'm having trouble figuring out how to create a formula where if start date is in the past and end date is in the future, having it automatically…
-
I want to do a serial IF this then that formula across more than one column. Please help!
My =IF(Child@row="Name1", "Parent1") and it worked to bring the Parent name into the @row, but I am trying to also add a few other Child/Parent combos into it as well. For example, In the Parent Column, I want to combine =IF(Child@row="Name1", "Parent1"), OR =IF(Child@row="Name2", "Parent2"), OR =IF(Child@row="Name3",…