-
Displaying a Report Full Size on Company Intranet Site
I have created a summary project report that is displayed on our company's intranet site using the embed code. It does not fill the page and the viewport becomes very tiny on smaller screens. Is there any way to display the report in full size?
-
If Statements and Calculations
I'm trying to calculate a cost based on whether a field is marked (and another field that contains quantity) or not. So, if field A is marked (checkbox), then multiply $5 x Field B. If field A is not marked, then multiply $4 x Field B. Is there a formula for this? Thank you, Jennifer
-
Update status to complete
Currently the “Days in House” column uses the Today function to show how many days it’s been since the application was received. I would like it so that when the status is changed to complete, the days in house shows complete as opposed to the date. What formula do I have to use?
-
Due Date vs Traditional Start-End Dates in Gantt charts
I've used the Gantt chart functionality to good effect, although it seems to be a little too "smart" when you set up dependencies, durations, predecessors, etc. What happens is the dates get too rigid and "calculated", imo. So I'm doing a basic list of tasks for a 3-person team. Most of the tasks are not linked by a…
-
Has anyone documented browser differences for Sights?
We are going to create an overview of the browser differences between Chrome/IE within Sites? The browsers act very differently.
-
Auto-Numbered Column - Conditional Formatting
Hi SS Users, I have a system populated column which automattically updates the date and time a row is amended. I am wondering if there is a way to conditionally format this column? Ie - if the last update was today (any time) go green. All rows with a latest update of anytime before go red. I know how to use conditional…
-
how to create an "interruption" in a schedule?
We are using Smartsheet as a manufacturing/production planning tool. I've created a sheet format that allows us to do exactly that, with tasks for individuals involving dependencies on other parts/processes. For example, a part is routed to engineering for design, the engineering manager for approval, purchasing to order…
-
Sending data to another sheet leaves formulars behind.............
Hi Team, Now that i have a sheet that completes the sales process from contract through too invoiced/paid. The row needs to go to another sheet, I noticed it leaves the formulas behind and when i send it back to the original sheet I have to re-enter formula in cells Can i duplicate a sheet so all the data and formulas…
-
Problems with Smartsheet add-in in Outlook web app (OWA)
When in OWA on my iPhone I click on the already installed Smartsheet for Outlook add-in just above the email body. I then get directed to the Add to Smartsheet window. I then click on the Connect to Smartsheet button, the add-in seems to want to load but then stops and shows the Add to Smartsheet window again as if nothing…
-
Formula to change a cell's value if date is in the past and another column's value is not a certain
Hello there, this is my first discussion and I have a feeling this might not be possible, hehe. I would like the Status (a dropdown list column) to change to a certain value ("Complete") if the Date (a date column) is in the past and the Type (a dropdown list) is not a certain value ("On Campus"). Thank you so much!
