-
Need help showing child row statuses in parent row status
Hi! I need help creating a formula that shows the child row statuses in the parent row. Is the below possible to build into a formula that I can pop into the parent row? Show “Not Started” if all child rows say “Not Started” Show “On Track” if any of the child rows say “On Track” Show “With Client” if any of the child rows…
-
IF CONTAINS INDEX MATCH Formula
I would like to be able to create a report where I can see Activity A, Finish (of activity A), Report A, and Finish (of Report A) in separate columns. I don't want to use group functionality in Row Report as it becomes messy when pulling it multiple activities from 50+ sheets. Hence, I would like to create two additional…
-
Possible to copy data to cell if only one of multiple columns contain information
Greetings, Is there a formula that can be used to copy the text from a range of columns only if there is information in that column? For example, I have Columns [Name A], [Name B], [Name C]. Only one of these columns will be filled at the any time. If one of those columns has information, copy that information into Column D
-
SUMIFS question regarding multiple criteria to summarize a cost column
I have two sheets I am using, one is my master sheet where I am collecting this information via form I created and the second sheet is what I like to call my data sheet. I got the formula down for if it's domestic or international, then calculate the sum. That's perfect. But I am trying to further break it up by month and…
-
Formula for determining whether a date occurred during daylight savings or standard time
I've got a sheet that I'm using to track the go live dates of items for a project I'm working on. These always go live at 10:00am in my local time (PST/PDT). The go live timestamps for these items need to be entered in UTC on the backend, when means the times need to be entered as 18:00 if the item's go live date is during…
-
Display Chart of Count per date
HI I have column for End Dates and Rows for Projects. I want to show in the dashboard a chart that woudl show # of prject per end dates. Can you help?
-
Join/Collect Column Name and field value
Hello Smartsheet folks, I need to collect all NONblank fields in TEXT columns *including the column name * that contain or start with the formatted date text MM/DD/YYYY and ... also, preferably organize them alphabetically (and/or in this case ...chronologically), example... below the header row are the columns with the…
-
Combining IF/AND/OR to return a value when multiple criteria are met
Hi Everyone, I am trying to filter out tasks on my Gantt chart occurring over the next three weeks. We found a good combination of filters that works for reports, however I want to be able to create a filter like this for the sheet so that the tasks can easily be edited in real time. Sheets do not allow for the hierarchies…
-
Automating hierarchy indenting using formulas
Hello All, Is there a formula to automate hierarchy? I am trying to use Smartsheet to create a family tree and dashboard. I have created a column labeled "Generation Tier" and I am using the people/person symbol to represent where individuals fall in the generations (child=1 person, grandchild=2 people, great grand=3…
-
Report on tasks for the next 3 weeks
Hello, I am trying to create a report view of my company's work schedule that only shows tasks happening over the next 3 weeks. I have tried using a combination of filtering by start and end dates in the next or last ____ days, however the problem is that it doesn't capture every task. For example, if there is a one-month…