-
Date formula query
What formula to use, to calculate records from today till 6 months down the line? And this rule should be valid at all times. In other words, how to calculate sum of values eg: count of total number of projects starting from today (26/April/24) till 12 months down the line i.e. 26/October/24? For sum of values starting…
-
Index Match Help
Good afternoon, I'm trying to get my Index and Match formula to work, it was working correctly and has now broken and I'm not sure why. I Have a "Weekly Metrics" Sheet I'm Trying to pull information over to the "Weekly Metrics 2" Sheet I'm trying to get the data from Weekly Metrics to Weekly Metrics 2 by matching the dates…
-
IF (And statement with date columns?
I have tried several ways including Not(isblank and now using the current as blank fields and ISBLANK, and 0s, now just with quotes... it won't read both coluumns. it is say complete, even if only one column is not blank. i have another column with a similar formula that works GREAT, but it doesn't involve date columns.…
-
I am attempting to create a formula that counts the number of applications approved each week?
I have five different sheets collecting information about 5 different applications and each sheet has a date-approved column. I want to collect the number of approved applications for each application type, each week (1-52). I wanted to create a column formula that will count the applications that are approved if the…
-
Ability to mark comments as "saved for later"
I have noticed that once you read a comment you can't "save" it or mark it as unread. I find this very useful to remind myself of things I can't reply to straight away, but want to go back to. A list of "saved for later" comments could be provided per sheet, or as an overall list of all the saved comments.
-
Update Sheet/Cell via e-mail
Is there a way that a cell/sheet can be updated from an email? In my search, some seemed to think that a sheet is related to a specific email address, that when emailed with the correct format to declare column/row/cell, the chosen contents would end up on the sheet itself. Is this possible?
-
Parent Field Added to Smartsheet Jira Connector
Hi Community, To support the new Parent field within Jira, we have added the Parent field for Jira Cloud and on-prem workflows. For Jira on-prem workflows, you can now select the Parent field (bi-directional) in addition to the Epic Link (bi-directional) and Parent Link (uni-directional) fields within the Jira Connector.…
-
Subitems "Child Tickets" Automations
Hello, I recently started a new intake system within Smartsheet for our Training team. The way they structure tickets is unique. They have Parent tickets and Child Tickets. The individual requesting assistance from the training team can submit a ticket, but that ticket could have several deliverables . Each deliverable is…
-
Why am I getting an error with Bridge when I try to pull a list of sheets within a Workspace?
I am trying to build out a workflow in Bridge that uses an API to make a call to the workspace and pull all of the sheets within that workspace. I am using bridge with the correct account that has owner access to the workspace and I have the correct authorization key put int he correct form parameters. The workspace I am…
-
Can you save a comment for later?
Hi all, I have noticed that once you read a comment you can't "save" it or mark it as unread. I find this very useful to remind myself of things I can't reply to straight away, but want to go back to. Is there a way to do it that I am missing?