-
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…
-
AI Tools Button Disappeared on Enterprise Plan
Hello Smartsheet Community, While I understand that Smartsheet rolled out AI tools for ALL accounts for a period of time that has now come to an end, Smartsheet's post (linked) says it should be available for Enterprise plans. https://help.smartsheet.com/2483096/AI-Formulas-text-generator I am on an Enterprise plan yet my…
-
Create a what if scenario using a late start date
I am working with a project timeline with dependencies. I have set up 2 additional date columns for late start and late finish where the late finish date is a formula for late start @row + duration. How can I set this up to calculate all the dependent late dates for start and finish? For example, I have several activities…
-
Formatting issue with my rowID field, anyone notice anything like this before?
I've used this same formula in a few sheets now. In the past it's looked like the first screenshot below. Using the same formula in any new sheet I create it's now putting the expected values for the second line on a third line below the "-", seen in the second screenshot. Here's my formula: =Account@row + "- " + [Story…
-
Change How Dependencies Appear? - Would rather see task title vs row number
My engineers and technical team(s) have requested a bounty list be created. Obviously setting up a dependency is easy enough; however, it would be be more useful to see the task name that the task is dependent upon instead of the row number. Is there a way to do this by changing a setting that I don't know about? Or would…