-
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. I am on an Enterprise plan yet my AI tools button is not showing. Does anyone have an explanation…
-
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…
-
if/and/or formula help
I have a set of training records data. Some have required due dates, some do not. I need a formula that set s flag (for items needing attention) if: the complete date is blank the complete date is > the due date (if there is a due date) for this condition, i need it to ignore if the due date is blank When I use this…
-
Index/Match Formula Referencing Contact Columns Providing Wrong Values
I need help with a formula. Since there is no way to cross-check against a group in a sheet, I have created a sheet listing all users of a particular group and am trying to use a cross-sheet reference formula in my intake sheet to be able to identify when a requestor is not already in the group so that I can add them for…