Hi everyone. is there a way for me to have the system automatically find the first Monday of the month showing in the the project plan start date without me having to change it every month?
Hello @Jennifer C
I found a relevant community post that may help with what you are trying to accomplish
Hope this helps!
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.