-
Formula to calculate the last update of a specific column
Hi. Is there a formula that will calculate the last time data in one specific column was updated? Thanks.
-
COUNTIF dates within the next year.
Hi There! I'm new to formulas and have tried lots of different ways to solve this, and still haven't managed, so any assistance would be appreciated. I want to count each Event Type which starts within the next 365 days. I have managed to count the total number of each Event Type in the column by using: =COUNTIF([Event…
-
Multiple choice option?
Good afternoon, A question was asked of me today if there is multiple choice column in development. We use the drop-down list column, but one that allows you to choose multiple entries would be fantastic. Blessings, Loann
-
Red Flag Formula
Hi All, Hoping to get some assistance with 2 questions. 1. In the Child rows, I would like the flag to go red when today's date is past the finish date AND % Complete is < 100% (ie the task is past the due date and not 100% complete). 2. The flag in the parent row (Black Circle) turns red IF any of the child row flags are…
-
Summarise Tasks into single cell
Hi there Smartsheet Community! I have been a smartsheet user for a few years now but this is my first post with the community (so i'll try my very best to describe my issue) I use two different sheets for planning in my company, which is currently manually updated. I am hoping to link these sheets together so that…
-
Creating Report without Sharing Sheet - I need help!
I am trying to find a solution...I have tasks related to confidential legal matters that are in a smartsheet. As I am breaking those matters down into tasks within the smartsheet there are some tasks that are not confidential and I need my administrative assistant to complete them without being privy to the broader issue…
-
Blackout Date Template
Does anyone have a good blackout date template I could borrow? Something that is easy on the eye when glancing at it? Thanks...
-
Routine reminder
Hello, I am trying to set up a routine reminder to notify staff to submit a report. I would additionally like to have it notify other staff to follow up to collect reports once the due date passes. I set these up as two different workflows but if I can combine let me know. I am also trying to find a way to not have to…
-
Automated Update Request Form Changes
I have created an automated workflow, using the Request Update step. This automatically creates the form to send to the user to update. I would like to change the way the form appears and allow multiple line entries. When I go into Forms, that form is not there to update. How do I update the automatically generated form?…
-
AverageIF help
I need help with an AverageIF formula. SmartSheet support gave me this formula for help: =AVERAGEIF([Column6]1:[Column6]22, >0). Essentially, I want the formula to give me the average of the numbers in the Time-to-Fill (Working Days) column BUT ONLY if they list Human Resources in the Department column. I wrote this…
