-
Automation - While copying/Moving Source Sheet to Target Sheet, how to update columns in Target shee
I have following questions related to workflow automation Is it possible, based on certain conditions in Sheet-A copy Sheet-A to Sheet-B and manipulate another column in Sheet-B (This Column is not in Sheet-A) through a function? Based on certain conditions in Sheet-A, will it be possible to delete a row in Sheet-B?
-
Inspection tracking template - functions
Hello, I am using the Inspection tracking template and it includes the following function: =COUNTIFS({MED1}, "No", {Date}, MONTH(@cell ) = $[Month#]@row) I would like to measure the number of violations per room, rather than per month but I am having difficulty knowing how to change the {Date}, MONTH(@cell ) =…
-
Pull dropdown menu options from one sheet into another based on a defined cell
Hello, I am curious if there is a way for Smartsheet to populate a designated column in one sheet with dropdown options from another sheet based on the conditions of a cell in the sheet the dropdown should appear in. For instance, if Sheet A has a specific value in the cell, you can pull in the dropdown menu from Sheet B…
-
Dashboard Abilities/ Functionality
I am making my first dashboard, and I'm wondering if there is a way to make a report appear in the report section when clicking on a widget. For example, I would click one of the dates below, and a report would populate in the section below for each year/ separate report (see image below):
-
Merged: Allow Certain Users to Make Edits to Specific Columns
This discussion has been merged.
-
Perpetual Contract Renewal Formula
Hello All! I am trying to create a formula that will automatically update the end date to a contract based on a renewal timeframe. For example, Contract Start date 12.31.19, Contract end date 12.31.20 at the end of the contract, the contract will renew for 1 year perpetually on the same date. Right now we are at 11.8.24,…
-
Perpetual Renewal of Dates
I have run into a little issue with a formula. It isn't adding the renewal timeframe correctly Formula: =IF(TODAY() > DATE(YEAR(TODAY()), MONTH([Agreement End Date]@row), DAY([Agreement End Date]@row)), DATE(YEAR(TODAY()), MONTH([Agreement End Date]@row), DAY([Agreement End Date]@row)), DATE(YEAR(TODAY()) - 1,…
-
Average value between two dates.
Hi, I have generated a report from different project sheets. I have a column (C) which has dates when a particular task is completed. Column D calculates the time taken to complete that task (Turn Around Time - TAT). I want to calculate the average TAT taken to complete a task in the month of Feb. I am not able to put two…
-
Published Sheet Calendar shows as 'Busy'
Mods: Don't merge this with 'Outlook Calendar integration showing time of event and not just the day,'. The only similarity that they have is that they deal with the calendar publishing functionality. When importing a sheet calendar into Outlook an event shows the user as 'Busy' all day and shades the rest of the calendar…
-
Group Columns in Grid
Hi! I use a really large grid-style Smartsheet to track all aspects of project development and health. It would be very helpful to have a way of grouping columns. The hierarchy for rows works great, but I think with columns I am just looking for a way to clean up my views. I feel like the best (and only) solution right now…
