Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
restrict users from editing curtain fields
Is there a way to restrict certain users from editing curtain fields? For example, we are using Smartsheet so users can enter info waiting for approval, but we want only admin should be able to mark off "check box" for approvals.
SheetNames appear differently in SSIS compared to SmartSheet
Hello, I am trying pull the information from Smartsheet Dynamically using SSIS. I see that the Sheet Names in SmarSheet is different to what I see from SSIS ODBC Source. For Example : Names in SmartSheet Displayed Name in SSIS * 801 Centre Road 801 Centre Road__8524479023343492s_(Home) * Canterbury Road Canterbury…
"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.