-
Managing dates
Hi SS Community! I have a feeling this maybe a simple answer, but I have looked on the internet with no resolve: I have "Project Plans" for each one of my projects. I use dependency settings. For dates I have Start Date, Due Date, ESTIMATED NUMBER OF DAYS TO COMPLETE, Estimated Completion Date and Complete Date (Record)…
-
Including attachments in message only automations
I have created a message only automation (cannot include the link to the smartsheet) to be sent when a new row is added via a form. The form includes an upload of a document; however, when using a message only format for the automated email I am unable to include the attachments. Any help is appreciated!!
-
Reusing a formula, but it's not working. I need to calculate deviation on End date.
=IFERROR(IF([End Date (Projected/Actual)]@row = [Target End Date]@row , 0, IF([End Date (Projected/Actual)]@row > [Target End Date]@row , NETWORKDAYS([End Date (Projected/Actual)]@row , [Target End Date]@row ) + 1, IF([End Date (Projected/Actual)]@row < [Target End Date]@row , NETWORKDAYS([End Date (Projected/Actual)]@row…
-
Adding date ranges to column headers
Hello Smartsheet Community, I saw something at the conference in November and I'm having a hard time remembering what it was called so that I can figure out how to use it, I think it was a "series". Here's my problem: I have several sheets that I am using to create "block based" schedules, each block is defined by dates,…
-
Can anyone please advise if Im using the correct format for the current year function?
Hi, I'm currently updating my formula sheet and Im looking for a way to have the "Year" automatically follows the current year. Im using the YEAR(TODAY()) function but its not really working for me.. Appreciate if anyone can kindly advise if I missed out something… Thanks.
-
Formula to return the Month
Howdy. I have tried to type this in so many ways. I've googled multiple variants of formulas and always get unparseable. i must be doing something basic and wrong. I simply want CellA to look at the calendar date in CellB (the Created Column) and return the Name of the month. I've attached a screenshot. Any help would be…
-
Returning a Due Date Based on Multiple Criteria
Hello, I want to return an Investigation Target Due Date based on a record Classification If Classification is Major or Critical, the Target Due Date is the Awareness Date + 45 Days If the Classification ia Minor, the Target Due Date is the Awareness Date + 60 Days Here is what I have, but it is showing as #UNPARSEABLE.…
-
sum of parent rows only, below parent and child rows
Itemized budget rows, which are the sum of child rows. All data entered in child rows and totaled in the parent row. At bottom of page, I want to total the parent rows only. Any way to do this? Screen grab attached.
-
Month Function Sorting in Report
Hello! I have a sheet that captures items and their start/end dates in a date format. I am trying to create a report that will group the items by the Month that the item is taking place in chronological order (Ex: All items with the target end date in January would be grouped under "January", followed by all items with the…
-
How to provide a link to a specific row in Dynamic View for end users
When using Dynamic View I need to provide end users with a link to a particular row/record. Is this possible and if so, how can I accomplish this. So far the link I've added takes them to the table view which is unacceptable.