-
"Save As New" doesn't retain Auto data...
I use a separate sheet to track projects in each calendar year. This means I need to carry over partially completed projects rows from the previous year's sheet to the next year's sheet. I've used a "Save as New" to duplicate the sheet, formatting and data, but my "Submitted" column which contains the "Date Created" now…
-
SmartSheet Names and Same Sheetnames in SSIS Differ
Hello, The sheet names differ in Smart Sheet and SSIS, the same sheet is shown with different names in SSIS when reading it via smart Sheet ODBC. Sheets in SmarSheet.Com Sheet in SSIS 801 Centre Road801 Centre Road__8524479023343492s_(Home) Canterbury Road Canterbury Road__4221359879415684s_(Home) Burke Road Construction…
-
Badly need help for a newbie in smartsheet
If column 3 is greater than 10, then i need the formula in column 1 be use and if column 3 is lesser than 10 formula in column 2 should be use. I am putting this formula in column 4. Please i just badly needed it! Thanks...
-
Can a Date autoupdate to the current date
Is there a way to set a date to dynamically update to TODAY? For example, I have a sheet with start date finish date and duration. I want to track how many days into the project without having to update the finish date continually.
-
Pull data from one sheet to another
I have a sheet that contains a list of expense transactions. In that sheet, I have a checkbox column and if the expense is tax deductible, I check that box for that line item. I would like a new sheet to pull over and list just the transactions that are checked as deductible. So that what I end up with is a list of tax…
-
Gantt chart & conditional formatting
Hi! Currently the conditionial format of gantt Chart bars is limited to the format option "entire row". As we use the entire row format for visualize the sheet structure (levels), it would be nice to have also the bar Color depending on a single column. Kind regards Michael
-
Scheduling update requests
Hi everyone, I need to be able to schedule update requests in 15 minute intervals, possibly can stretch that to 30 minute intervals. However, when I am scheduling future delivery my only options are "on the hour". This will not allow me to get real-time updates if an assigned task only takes 25 minutes to complete. Is…
-
Alerts/Notifications based on cell color
I would like to create an alert. If a cell turns red in a delivery date column, email PM assigned to PM column and another editor within the sheet. Do not see how to establish an alert just based on change of color.
-
Sheet name in report (sheet name system column)
Hi, I have a Report that shows the Sheet Name (System Column). It's coming in formatted as Strikethrough with a colored background. Since there isn't a Sheet Name System Column available on the actual sheets, where is it getting this formatting from? Thank you.
-
If or if error function
Hi Community I have three columns in the sheet, 1st one showing the entitle commission, 2nd one showing the commission paid date, the third one showing the commission due to paid, There are always an amount showing in Entitle Commission, If we have paid the commission, I will input the date on the commission paid date. The…
