-
Date Formula Reminders
If you set up a date on a formula, can Smartsheet still use a reminder. The questions is here that actual text in the date field is a formula displaying a date. The items are not showing up on the calendar and that is concerning. Thank you in advance.
-
Combine 2 IF formulas
Hi, Can someone help me with combining these 2 formulas? =IF(MONTH([Date Raised]12) = MONTH([Date Raised]1), "Yes", "No") and =IF(YEAR([Date Raised]12) = YEAR([Date Raised]1), "Yes", "No") Regards, Samad
-
Counting rows between two sets of dates
Hi Smartsheet Community, I'm trying to figure out how to count a row if the date column falls between a set of dates. Basically, I'd like to use the COUNTIF formula and count the row if the date is between 07/01/17-09/30/17. Any ideas on how to do this? I'd rather not add in an additional check box, just base the formula…
-
Help With Formulas
I am attempting to automate the RYG column shown in the screen shot below. I need the formula to look at the finish date and status columns if the status is not "Done". I need some feedback on the formula that I am using below. =IF([Finish]1 < TODAY(), "Red", IF([Finish]1 = TODAY(), "Yellow", IF([Finish]1 > TODAY(),…
-
What's the statute of limitations for deleted workspaces?
I'm the account admin for my company. A user was terminated with no notice in November of 2015. I removed her account a few weeks after that. She had shared some sheets with me for technical assistance and I kept them around for at least 90 days. Sometime fairly recently (can't remember exactly, might have been less than…
-
Filtered Views
Is there a way to share only filtered views. I'd like the user to only be able to see and view specific rows.
-
Performance issues with LOOKUP() formula
Hi, I have a Smartsheet with around 3600 rows and ~20 columns. After introducing a simple LOOKUP() into one column of these 3600 entries, the Smartsheet page has become dead slow. Browser is giving error "An application is slowing down ...". Tried opening this sheet in both Firefox and Chrome browsers but same result.…
-
Windows 10 Touch Pad
Can't get the two finger touch pad scroll to work with the Gantt charts. It works every where else, including scrolling through these discussion topics. On for the Gantt chart, the whole chart moves slightly up and down as opposed to the rows scrolling. Anyone else have this problem?
-
Task names in Gantt are gone
I was updating my sheet yesterday and payed no attention but this morning I've noticed that all of the task names on the Gantt chart are gone and I can't seem to find a way to get them back. Any ideas? Thank you in advance!
-
Populating webforms with data from sheet
Hi friends, I will try and explain what I am trying to achieve: I have an issue tracking sheet with columns effectively divided into 3 sections: 1) Originator raises an issue on a webform, on clicking "submit" the sheet is populated. This works fine. 2) A webform is then created from the cells in the row corresponding to…
