-
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,…
-
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?
-
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,…
-
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…
-
Take Photos in Form with Tablets
We use Surface Pro's in my department for tracing areas to ensure compliance. When we complete our form (and we do several during our walkthrough), Smartsheet will not allow us to take a photo directly through the File Upload option so the photo will be submitted to the sheet like it does when using our phones or iPad.…
-
Merged: Searchable Columns
This discussion has been merged.
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Version Control/Backups That Maintain Cell Links
I have seen some posts referencing similar pain points, but thought I would try to distill it into one idea post: Smartsheet is awesome at so many things, but one place where it lags behind other cloud productivity solutions is in its ability to backup, back rev, and implement version control. Yes, you can view history on…
