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. Archived 2017 Posts
Archives for July 2017
Discussion List
Week Ending Date
Hello, I am creating a Safety Audit Database. Similar to Scheduling principles, we keep track of all data entries by two dates. ACTUAL DATE and WEEK ENDING DATE (where Week Ending date is Sunday) We use a formula in Excel to do this but I am not able to replicate such formula in smartsheet. Does anyone know how to do this?…
Master Roll Up Sheet and Reports
Hi there. I'm still rather new to using Smartsheet and am being tasked with really thinking outside the box to creatively build views and reports with Smartsheet. I am currently working on a project where we have 8 auditors (with 8 separate sheets of their own). Each of the sheets has categories and subcategories of the…
Can I add an existing licensed user to my account?
Is it possible to add an existing licensed user who is part of a different existing account to your account and make them a resource viewer?
Information in cells mysteriously disappears
When my smartsheet is open and I am not doing any editing, I find that cells mysteriously empty themselves and are marked as changed. The RYG balls also just disappear in the priority column and are marked as a change. Sometimes it is impossible to restore the information as it keeps reverting to being deleted. Only one…
Over riding dependency per activity without deleting the tie
I am having problems holding start and finish dates for out of sequence activities that are in-progress or completed. So if the activity is in-progress or complete and not all the predecessors have completed as planned and the dates will continue to push as the predecessor pushes. I would rather not cut the tie to hold the…
create a location updated index from 1-10
I need to create a count of 1-10 that always stays at the top of the column in the correct order even when the sheet is sorted and when web forms are used to input information to the top of the sheet. Sounds simple but I have no clue how to do this without drawing a circular reference and without the ability to reference a…
Automatically scheduling work on special days (typically weekends)
for my projects, weekends are not workdays. But, at the cumination of almost all the projects, special events (like commercial moves) must be scheduled on weekends - not during workdays. I'd like to set dependencies for all the related events, so that if a Saturday move gets rescheduled to another weekend, all of the…
conditional formatting
Hello!! Hopefully someone can help.... I would like to run a conditional formatting where I enter a number in column 1 and that will produce specific text in column 2 I can only see option of changing the cell colour and not having the condition produce a line of text Thanks Celine :o )
Autofill a value
Hi. I'm new at building formulas in Smartsheet. I have a numeric column that I want to autofill a 1 if no value is entered. Can someone help me with this?
Using reports to create Totals
Hi I am pretty new to Smart Sheet and have mainly used it for Project Plans so far. I am now looking at using it for forecasting for delivery consultants. I have created a sheet and form for them to enter forecasting for delivery for a particular customer in a given month. I would however like to be able to create a…