-
Source Table for multiple sheets individual drop down columns
Good Afternoon, I have multiple sheets (50+) that utilize drop downs to look up data specific to an individual record. The individual record for example would be a location number. We add locations on a monthly basis and i need an easy way to update the drop down option from a central location, vs having to update each…
-
Notifications or Reminders
Hi, Is their a way to set auto Notfcations when a cell is a nagtitive number my example on a sheet is if Payments to A/P (A/P is payments made to Vendors in that month) in Box A/R Payments Recevied (in AR Box i have monthly Income Recevied to Date) Net Cashflow =Ar -AP = Cashflow Available if the amount is in a minues i…
-
Option to Open to Today's Date not saving
Hello, Not sure if anyone else has seen this but when I select the Timeline Display option to Open to Today's Date, the option doesn't save. I need to select the option each time I open the sheet. Seems like a bug or I'm missing something. Thanks
-
Due Date vs Traditional Start-End Dates in Gantt charts
I've used the Gantt chart functionality to good effect, although it seems to be a little too "smart" when you set up dependencies, durations, predecessors, etc. What happens is the dates get too rigid and "calculated", imo. So I'm doing a basic list of tasks for a 3-person team. Most of the tasks are not linked by a…
-
Summary Report of Multiple Sheets: Modified Date
Hello, I would like to creat a report/sheet that lists multiple other sheets, and returns information on either the "Modified By" or the "Modified Date" (or both), for each sheet. I'm trying to monitor all activity across 20+ other sheets, to tell when each sheet has been updated. I know our SysAdmin can run a Summary…
-
Aging Items Based on TODAY
Hi, I'm trying to use the TODAY function to work out the age of an item. In Excel I would have a cell with =TODAY(), and do a calculation to subtract the date of the item from this. I have tried using =TODAY(), =TODAY, TODAY, TODAY(), but can't get it to bring back today's date (got #INVALID COLUMN VALUE, #UNPARSEABLE or…
-
Formula for basis of reminder generation
Hello, Here is my scenario: I have two directors who need to be notified upon the completion of a form based on their customer. It seems that the easiest way to do so is to utilize the reminders based off the date generated once the checkbox is marked complete. Right now I have columns with the contact list for the two…
-
Auto order (by date) in Card View
We have a project workload sheet that has columns of who a project is assigned to, completed, and new. There is no sorting or auto ordering of the projects that happen in each column (by start or end date). You can sort rows in the other views, but not card. Help, please.
-
Recurring dates on a calendar
I am converting some calendars from Sharepoint into Smartsheet, and can't figure out if or how I can make events recurring. For example, I'm building an on-call schedule and the schedules are regular. Every so many weeks, each person takes a turn. Has anyone been able to accomplish this? I don't want to have to enter each…
-
Count "green balls" within a range
Hello I'm am wanting to count "green balls" within a range. I have used =COUNTIF([Site Attended]11:[Site Attended]26), "green") I'm have the result #unparsable I am a new user so would apprecate the help. Thank you