-
Report | Date column showing time stamp in column title
Does anyone know why this is happening? I have many date columns in this sheet and for some reason this one (Store Closed Date) is showing 7:00 am?
-
Data entered in form not visible
I had a student enter client data into a form, but I do not see the data in the sheet. However, the summary sheet shows that there are far more records listed that visible in the sheet. There are no filters set, and no columns are hidden. Is there a reason that the data would not show on the grid? Thanks
-
One Dependency for the start, another for the end?
Hi... I'm trying to set up a project that has a task (weekly update reports) that begins with one dependency (e.g., start of project), and ends with another dependency (e.g., on-site work). There are still some administrative tasks that continue after the on-site work is done, but I won't have to continue the update…
-
Help with formula with RYG Balls and Start/End Dates
Hello, I am trying to clean up a program management smartsheet. I am wanting the status column (RYG balls) to communicate with the % complete column and the start and end date column. This is my current formula: =IF([% Complete]93 = 1, "Green", IF([% Complete]93 > 0.49, "Yellow", IF([% Complete]93 < 0.48, "Red"))) With…
-
Countifs Name reference
We are working on a formula where we are needing the counts of two names in a column. So if the range column we are pulling from has both John Doe and Jane-Marie Doe, we want the count of how many times that occurs. This is the formula we have and it is not working: =COUNTIFS([{A Great Place to Work Range 4}]:[{A Great…
-
Help with the Alt-Enter function
I have not been able to find the answer to this question in the forum. I have tried using the Alt-Enter to enter data on multiple lines in a cell. However, when I leave the cell, the data reverts to all being on the same line. It is not displayed on separate lines as I want it to be. What am I missing or doing wrong to…
-
Using COUNT and CHILDREN functions to return non-blank rows under parent row of a different sheet
Hi Smartsheet Community, I need a formula which will allow me to look up the number of non-blank rows under a parent row from another sheet and return the value. As an example I've attached a screenshot of my reference sheet where I am trying to count the non-blank rows under the parent row "Over 50%", some of the…
-
Can I change tasks visibility in a shared smartsheet?
Hi, I am trying to find out the best way to work with smartsheet in a particular scenario. I have project smartsheets that outline project milestones, and tasks within. This sheet is shared externally to my team for collaboration. In many cases, some of the tasks might drive subtasks, or small actions that the internal…
-
Accessing Children of Children if it meets certain Conditions
Hi, I'm having trouble getting a formula to help me tally info for a dashboard. I have a sheet that is tracking the requirements of several capabilities of a system that we're migrating. The Column called Core Capabilities, has 4 children (Categories); Critical, High, Medium, Low. Each of those categories has a range of…
-
Auto Date Calculation
Hi, I have 3 column's - Days, Start Date, Completion Date. I would like to enter days and start date, and let Completion date auto calculate. So for example if I enter 30 in days and 6/14 in Start Date, I would like Completion Date auto calculate to 7/14. Any tips on the right formula for this? Thanks!
