it is possible to make a report with sentences for the next two months and to automatically update the tasks for the next two months after these two months ??
I'm not clear as to what you're asking. Can you add some information for clarity?
If you're looking to build a report that stays up-to-date with the next two months worth of tasks, then you could set your criteria in your Report Builder to be "is in the next" 60 days. That should do that part.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
Hello! I'm looking for some help with the Netdays formula. I am trying to create a helper column that tracks the number of days between a date column titled "Start Date" (when a project began) and a date column titled "Completion" (when a project is completed). My current formula, which is just a start, is this:…
Hi, I have a sheet with ranges identified as SUBJECTM and FLAGM. On my summary page, I have a list of all variables, with the column identified as Metric. In the main sheet, the subject field is a series of checkboxes with the ability to select multiple options (think : maths, english, french, art). I want to count the…
©2024. All Rights Reserved Smartsheet Inc.