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…
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 …
This is unlikely possible with Smartsheet but I'd LOVE to be proven wrong :) I'm trying to Highlight Cells in the row that have errors. There might be one to twenty columns in that row with errors at …
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 formu…
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 …
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 t…
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
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…
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 avail…
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. H…