-
Using Smartsheet Forms
I have this schedule above (took out the names/privacy) for weekly schedules with my team. Normally there is a time frame in each cell for thee week like 9:00-5:00. Each week pulls down, I just have week 3 as an example. And this form: Is there a way that I can have someone enter in their information, for example if…
-
Dynamic dates
Very new to this program so hopefully this is not a stupid question... I need to set a sheet up where there are fixed times within a 4 week cycle for certain steps to occur. For instance we can only order a certain pack on Friday of week 1 of any 4 week cycle. Is there a way to set this up so if the predecessor finishes ie…
-
How to create metric from timestamp in sheet
I am trying to create a metric in my dashboard that shows the average time of day that each contact submitted their request. The specific date is not relevant. Please help Thanks!
-
Limiting Characters in a Cell/Date Validation
I want to limit the number of characters that a requester can enter into a cell via a form. The use case is that the user is entering a new request for consideration into an Intake Form. In assigning a name to their project request, we want to limit them to no more than 25 characters, based on limitations from another…
-
Is it possible to add weightage in Smartsheet?
Team, As part of my requirement, under my Survey, i have questions with list of choices. So i would like to pre-configure the weightage to these choices so that, once the end user selects a value, it should automatically populate the weightage in another table. Which should be later used for reporting purpose (if possible…
-
If Cells not blank equal max date
I have a sheet with 7 columns that have dates (was checkboxes but could not get it to work) I want an 8th column to populate the max date from the 7 columns ONLY if all columns have a date entered. Basically I am tracking when people submit multiple documents, once all are submitted (i.e all dates entered) I issue them a…
-
COUNTIF and CONTAINS and OR
I have 2 columns that have multiple select drop down options. I want to create a formula that allows me to identify a PLO and then count the number of times "BE" OR "BC" OR "BL" or "BM" appear throughout the entire sheet. so: =COUNTIF([PLO Alignment]:[PLO Alignment], CONTAINS("A.1 Environment",@cell), Sections:Sections,…
-
Conditional Formatting Not Working
I use conditional formatting all the time. I have a new sheet that I can't get any rules to work. Can this feature be broken on a particular sheet; or can there be something hidden I'm not aware of?
-
What's wrong with my formula?
I know the answer has to be something simple, but I am just not finding the answer. If the Favorites column has a check mark, then populate (the cell containing the formula) with the Initiative Project Name. Maybe I'm not using the right function? 🤔 It seems logical to me, IF this row has a check, enter this data from the…
-
Combining If/then with date population
I am trying to figure out a way to auto-populate a date, but only IF a specific condition is met. (Screenshot below) I used the formula =WORKDAY([1st Test Date] 1,6) to auto-populate the "Second Test Scheduling Date", but I would like this to only auto-populate if the column "1st Test Results" is "Positive". Any tips? I'm…