-
Ability for Forms to Add totals within the form
Is there a way to have a form add a total? For example - we are building a form for potential exhibitors to apply to have a space at an event. On top of their booth space fee, they have the option to add on additional items. We would love for a way on the form to show what their total fee (booth space fee + add on's) would…
-
Formula Help
Hello, Looking for a little quick assistance. Not sure why I can figure this out, but I guess I'm just not as intuitive with the SmartSheet logic. I have a metrics sheet that I am using to provide data from other sheets to populate a dashboard. I currently have this formula and similar formulas that pull data within a…
-
Count rows by % Completed?
Is there a way to count rows by % completed. For example, how many items are greater than 50% completed? I'm getting UNPARSEALBE I tried a formula like this (but also tried converting % into decimals.... =COUNTIF([% Completel]:[% Complete], >50%) Note: also see that the % completed column is part of the Project Properties.
-
Can you auto-replicate rows in a sheet based on a cell value?
We're putting together a Proof of Concept for our project management team. We're "this close" to being able to replicate all the functionality they need. But, we're stumbling on one item. They would like Smartsheet to automatically replicate a row when the value in one of the cells is set a certain way. Specifically,…
-
Auto fill column?
Hi, everyone. I don't know if this is a possibility or not but I'm hoping someone can help. I'm looking to see if it's possible to set a formula/equation/conditional formatting so that what's entered in one column will autofill another. Example: I have a column called Access Requested (dropdown) and another called Type of…
-
Calculating a day from a date
I've got a column (called "Dates") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), "dddd") brings back an #unparseable error in the cell. I've tried using brackets instead of parenthesis but it hasn't worked. I must be messing up the…
-
Start & Finish dates based on separate predecessors / or formula in duration
I am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have the actual production line have a start day based on the production start line and the finish date be the last ship date.…
-
Returning a cell value if false
Hello all. Pretty new to Smartsheet here. I am trying to create a call that checks if one column, Trip, contains a value 1st, if it does NOT contain the value 1st, I want it to populate the contents of the corresponding cell in column Job Description. I keep running into errors attempting to nest the cell call =[Job…
-
Showing multiple true checkboxes as joined or concatenated text in another column
I have a volunteer submission form which has about 10 columns that exist as just checkboxes on/off - each of these relate to a conference work area and volunteers often select multiple. To easily view the data for a single person/row without tons of scrolling and looking up and down at column titles, I want to aggregate…
-
ISdate or ISblank
I'm trying to achive this: Field Maintenance: If my field Last maintenance date is empty, i need to put today's date, if there's a date i need to put Last maintenance date + Frequency (day) Not able to make it works with isblank or isdate, any other idea? thanks
