-
Help Creating a formula using Children
Hi! I currently am experimenting with Parent and Children Hierarchy to clean up my sheets. Below is a screenshot so you can see my mock up page. The issue I am running into is when I add an additional "Project", my formulas in the columns on the right are pulling from the whole column. I am having difficulty creating the…
-
Today / Yesterday formulas
Hi all, I need to create a dashboard to include all calls made to clients, either today or yesterday (the idea being that the charts would change on a daily basis). My issue is that I don't think I can use the Today or Today -1 type formulas as the date column is NOT a date column type, but a text column type. I can't…
-
Form Information is Not populating in Sheet
Hello, I have a Smartsheet Form set-up that adds new rows to the bottom of the sheet. At 6:30 AM MST 10/20/2020 this feature/feed stopped working. I entered a test form in about 5 pm MST I looked at the properties of the form and it still says last entry was 6:30 am. Yes I have gone to the sheet and scrolled all the way…
-
Copy cell above in formula
I have created this formula: =IF([is Child]@row = "T", [Estimate Number (1)]1814, VALUE([Estimate #]@row)) I am trying to copy the estimate number from the row above if the current row is a child. Works fine until the sheet is sorted. How do I change this formula parameter "[Estimate Number (1)]1814" to copy the cell above…
-
Auto Fill "Completed By" Column based on Checkbox
Hi all, Is it possible to have a column auto-fill in the name of the user who checks off a task as "done"? I know you can see it in the Activity Log, so I know Smartsheet is collecting this information, but I can't figure out how to get it into the sheet.
-
Hi Smartsheeters,
Can you please help me to create a formula, As in main sheet according to market, it should look up in reference sheet, for example: if in main sheet the Market is Spain , then we have look up in reference sheet , it should match the market row then it should multiply HOURS COLUMN IN MAINSHEET * IC hourly cost in reference…
-
Showing % Complete of Children Rows to Parent
Hi There I am managing projects that are made up of parent, children and grandchildren rows (tasks that make up the projects). I would like to count the tasks that make up a project and then count how many are complete to communicate % of project complete to our business leaders. Is this possible using some form and…
-
At Risk If/Not formula
I am trying to build a formula where "At Risk" will be flagged IF the following conditions are met: the Status is not Gray (n/a) or Green (complete) AND the End Date has passed I tried this formula but something is missing, it comes out unparseable. =IF((NOT(Status@row = "GRAY")), 0, 0),IF(AND([End Date]@row < TODAY(),…
-
Index/Match
I have a smartsheet that has a column for "State" and then a column for "Territory". How do I write a function that if a row within column "State" equals say "TX" than the column for "Territory" within the same row = "West". I would need to do this for all states broken into 4 or 5 territories.
-
Novice - Date Status Changed
I want to track when a project changes Status. I'm primarily using the Card View and want the date the Status changes or the project switches swim lanes, to have that day's date. For example: Old Status: Reviewed Date: 10/19/2020 New Status: Completed New Date: [Date Status was changed]