-
Alerts for Created (Date) Column
I can't seem to find a way to set an alert if the Created Date changes. This would essentially only alert me when a user filled out the web-form and not if someone changed the contents of the row. I have an employee that needs to know when a new row is added, but doesn't need add'l updates when other employees massage theβ¦
-
Salesforce and Smartsheet Integration
Hi Everyone - Have any of you used the new Salesforce/Smartsheet integration with project plans? I see and understand how it can push and pull data as reports between the systems, but I need to figure out how to take a cell in Smartsheet (Due Date or Date Completed for instance) and map that specific cell to a specificβ¦
-
Convert date format to mm/dd/yyyy
Is there a setting or a formula to convert the standard yy in smartsheet to yyyy?
-
Using Report builder to find past due 'Days' tasks
I have a sheet that lists bugs and it has a 'Created Date' column (not a system column, just a date column). I need to generate a report of all issues that are 'Open' and 30 days old. I can check for 'Open'. But I wasn't able to find a way to check for 30 days old in the report builder. Can I do this just using the reportβ¦
-
Other Sheets In Resource
In my Resource View following deleating a sheet now have "another sheet" which i cannot get rid of. This shows my resource 200% now Any thoughts?
-
Tracking a date change
I am new to Smartsheet in a company with limited knowledge about the features. We use a combination of sheets and a web form for 'ad-hoc' requests that are managed in a queue. In the queue, there is a "Due Date" column. This date can change over time and the manager for the area would love to be able to track that changeβ¦
-
I'm looking for a way to calculate time of day based on predecessors.
I have a very specific need to a time intensive schedule that requires time of day (TOD)Β to calculate based on predecessors. Currently I have been manually entering TOD of Start Time and Finish Time in general columns but would prefer these to be formula driven. Has anyone done this?
-
Counting checkboxes
Hello, I am counting the children of selected check boxes and then seting a ball color with formula bellow: =IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 2, "", IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 1, "Red", IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 0, "Green"))) This works fine but, when I have more than three checkboxesβ¦
-
Maybe the wrong software?
Just got off the phone with support and was told we could not take our timeline down to hours. We are going to look into our purchase to see if we purchased the right application. Otherwise how do you make a schedule work?
-
Bug: Comparing max(system date) to system date returns incorrect result
I'm trying to retrieve the latest created date and compare it to the date-time. I was expecting to get a date, not a date-time, and that would be OK. =MAX(Created:Created) returns 11/29/16, which is what I expected. However, comparing the [Created] column to this value returns some rows that were created on 11/28: I'veβ¦