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
SUM between Sheet 1 & 2 for Time range
Hi everyone, I'm stuck and need a little help. I'm trying to group Time ranges either both columns "A & B" if doable, or just column "A" into multiple 3-Hours bucket for the day with =FLOOR or similar and pick the highest number of Customers from same bucket/ time window of 3-hours with =LARGE from Sheet 1 & Sheet 2 then…
IF(AND Please help
=IF(AND(Status2 = " WON", [Probability Hit Rate]2, 1, [Value Of Jobs]2))
Computing duration from a min and max column
I'd like to support a Min Duration and Max Duration, and then compute Duration as an average of the those two and be reflected in the Gantt Chart. Is it possible?
Using Webform to update/edit information of a row
Is it possible to use a look up function in a Webform to find a specific row of information, then populate fields related to that row, and make changes in the Webform to modify the related information to the row in SS?
I am using bubbles on my webform, but if someone changes their mind and wants to not check the bubbles, how do they do that? (it is not required). With the dropdown they can just go back and use the blank - but in the bubble format they don't have a way to UN--CHECK the bubble. HELP! Kawehi
Automatic reminders based on dates
Hi All, very new to smartsheet so please be kind :) I have a requirement whereby I need to badger suppliers to ensure that they will deliver on schedule, so I'm hoping to do the following: Add a column for expected delivery date Add a tickbox for "will require chasing" Have a reminder automatically set to trigger at 50% of…
Conditional Formatting Do not modify current value if condition in other field fails
Without creating another column, I am trying to update a current value only if the condition is met in my modified by field. My formula (below) works when the condition is met. How do I tell SS to leave the current value as is if the condition is not met? =IF([Modified By]1 = Owner1, " ", Modified1) Background: Above…
Counting overdue dates
Hi, I'm trying to include a formula that counts overdue dates (by inputting 1 in another column and then using SUM). It works but if the date is left blank it still includes '1'. The reason I have some black is it's the only way I've found to 'check it off' as sent. Any suggestions greatly appreciated.
adding service records to a row
I have a plant & vehicle register that I want to add service records to. So each row is a vehicle and I want to keep each service record as a history of the vehicle then I need to export the record for my clients is there a way to do this without adding extra columns?
Locking Formula ???
Hi Team, I find my formulas change when i filter etc. e.g. =SUM([Value Of Jobs]2:[Value Of Jobs]85) =SUM([Value Of Jobs]18:[Value Of Jobs]85) My top row which i use to calculate columns keeps changing. How to I fix or lock formulas please.