-
Autofill compliance
User Mgmt: I have users entering data into a sheet. They are not always inserting lines in a manner consistient with Autofill and some formulas in hidden columns are not filling in, "breaking" the sheet. Does anyone have any strategies for making sure people follow rules that allow autofill to complete? I have trained ad…
-
Security loophole
We have a sheet containing sensitive data in several columns. We limit the visibility of this data by hiding the columns, so only Admin users on the sheet can unhide/view the data. However, any Smartsheet licensed user, including those with only Viewer privileges, can circumvent the sheet security by simply saving the…
-
Calculating lateness
I'd like to indicate when activities start slipping behind baseline start dates, using conditional formatting. To do this, however, I need to be able to calculate the difference between the Actual start date (entered manually) and the Baseline start date (locked). What is a formula to do this calculation?
-
IFERROR
The formula underlined works perfectly when there is a date in the relevent cell. When their is no date (data) it returns a error. Ive had a go at trying to figure it out below. =DATE(YEAR([Invoiced Date]2), MONTH([Invoiced Date]2) + 1, 20) =DATE(YEAR,IFERROR([Invoiced Date]3),""), MONTH,IFERROR([Invoiced Date]3),"-"), +…
-
Update End Column When complete is mark
Hi there I will like to know ...is there a way where the end date column marks by his own every time i mark the complete check box on rorws. I will like to know is there a way to do that. thanks
-
Web Forms - Can these be customised further
Hi Can the forms be customised to allow a better layout -? for example if you have 5 radio buttons then these warp on to the next line and this looks messy. Is there any control over CSS? Thanks
-
Feature Request: Ability to Modify the Working Days of Specific Line Items
While building out a Gantt or waterfall chart in Smartsheet, it is not uncommon to have some tasks that can only occur during a weekday while others can occur on weekends. It would be great if one could modify the working days at a more granular level, that is the ability to edit the working day property of each line item…
-
Copy Sharing when duplicating (Save as New) sheet.
We create (copy) a new sheet each month, keeping all the formatting but not the attachments and comments and cell lnks. Is there a way to duplicate the sharing as well. The sheets are in the "Sheets" folder. I have created a Workspace with the sharing, but when I move or copy the sheet to the "Sheets" folder, the sharing…
-
Not new, but I wonder if there is an smart advance tutorial for Smartsheet for not so smart people
I love using Smartsheet, but I am almost positive I am using just 0.00001% of its capabilities. I appreciate your input.
-
Schedule Duration Issues
I've been working in a CPM schedule. The original showed a 141 day duration, starting 12/12 and ending 05/04. I'm updating some of the relationships as I had to rearrange the work pattern a bit, now my schedule shows 144 days, starting 12/12 and ending 6/29. Does anyone have an answer as to how I gained only 3 days…
