-
Set Target End Date first and have predecessors fill in
Is there a way to set the Target End date in a project sheet first and have all the preceding dates backfill? When I tried it, an alert comes up that says "…will result in the removal of all predecessor relationships in this row". I've looked into the Workback Schedule using the Project with Hard Deadline and Gantt…
-
Dynamic drop downs- possible in smartsheets?
My boss recently challenged me to see if I could add some logic to our project plan smartsheet templates where if a user entered in an Assigned To column can dynamically narrow the values available in a Role column to show only the roles the person selected in the Assigned To column is eligible for. For example, let's say…
-
Sumifs- With a start and end date range Errors
I am struggling with this formula. My Syntax is correct, the lay of this formula works until I add my date range. I have tried having both my formula column and the referenced date column as date, dates restricted, as well as just Text/number. I have a years worth of data I want to calculate grand total of sheet, which is…
-
Any way to update formula criteria with drag-fill
Hello, I have a sheet with around 3000 rows all of which have a date received and I am trying to count how many were received per week. Currently I have a helper column which has the week number (1-52) and have =COUNTIF([Week number]@Row, =1) which works but I am wondering how to then extend the formula to automatically…
-
Automation to record values from one smartsheet onto a new row on another smartsheet once a week?
Hello, I imagine the answer(s) to this question already exist but I haven't had luck finding them, please point me in the right direction, here's my situation: I have a Smartsheet ("sheet 1") that my team records numbers on during the week every week. "Sheet 1" has 100 rows, and there's one column ("column x") in "sheet 1"…
-
How to change auto number formula when value changes in a column
Hey! It's my first time posting here, and I really hope someone can help me! 😄 I have a formula which I'd like to modify. I will explain what I have and then how I'd want to change it. I have a formula that auto-numbers indented rows, and resets the count to 1 for every parent row, like this: → RowId column that is of type…
-
Connecting End Date or Duration from Jira to Smartsheet
I understand that I cannot bring over the end date from Jira to Smartsheet when there is dependencies/ one directional. Does anyone have a tip to use a duration field in Jira to populate the end date in Smartsheet? Or any other way to get an end date in Smartsheet from Jira? I have dependencies enabled in Smartsheet and I…
-
Formula to record and store a value at the start of each day
I am looking for a way to have smart sheet review an average time at the start of the day and record that value. I would then want visibility of that data over a range of the last 7 days. I am using this in a chart to show progression towards the goal of 21 days.
-
I am receiving a zero "0" in the cell
I don't know how to ask this question. I have cell formula below. When I run the automation, I receive a "0" before the drop-down value in the cell Any help would be appreciated. Thanks
-
Action : change cell value
Hi Community, I feel like this is simple question, but I can make it happen. If I want to using change cell value in automation workflows, can I change the cell value by using formula? Cause I use the formula to change, the result always add ' in front of the formula…(show as the pic below) Besides, can it make the value…