-
Fixed Cell Reference
I have search the db for answers but likely have my terminology mixed. I have a sheet which is populated by clients via a web form. New entries appear on the 1st line. I want the value in 'Bears 1' to populate in another sheet or on the same, doesnt matter. The specific cell is key as this is the most current value.…
-
Sheet Roll-Up
I'm curious if there is a way to have a "higher level" sheet that pulls from other sheets. That way, each individual on our team can have their own projects with greater detail and our supervisor can see a higher level view of everything being worked on.
-
HELP - Enabling CAPTCHA on a Form
I have a business critical form that's getting spoofed (500+ entries in ~3hrs) and am trying to enable CAPTCHA but I can't seem to get it on the form. Here's what I've done using Edge and Firefox: Edit form > Form Options > Checked 'Enable challenge/response for additional security'
-
Formula issue for conditional formatting
I am trying to set up a formula to allow for conditional formatting but having some problems. This is the formula I'm trying: =IF([Actual]19 >= [Target]19, IF([Actual]19 < SUM([Target]19 * 0.1), IF([Actual]19 > SUM([Target]19 * 0.1), "GREEN", "AMBER", "RED")) but the result leaves the cell blank with no error message. What…
-
Help with #DIVIDE BY ZERO error message
Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on some of the rows. The formula in question that is currently being used…
-
Dynamic SmartSheets an Option?
First-time poster and amateur SmartSheet user here. I have an existing Excel spreadsheet for our association's Marketing Schedule. Each month has a row and each marketing medium (newsletter, magazine, social media, online ad, etc.) has a column where I list all of the programs and services that will be featured in that…
-
Show only own tasks in calendar
Hi, I am new to Smartsheet. I already searched for this topic, but wasn't successful. By standard, the calendar in Smartsheet shows all tasks of everybody. I imported the calender into my Google calendar (via ics and directly). There also all tasks of everybody are shown. Is there a way to show only your own tasks (you are…
-
Formula to calculate the last update of a specific column
Hi. Is there a formula that will calculate the last time data in one specific column was updated? Thanks.
-
COUNTIF dates within the next year.
Hi There! I'm new to formulas and have tried lots of different ways to solve this, and still haven't managed, so any assistance would be appreciated. I want to count each Event Type which starts within the next 365 days. I have managed to count the total number of each Event Type in the column by using: =COUNTIF([Event…
-
Multiple choice option?
Good afternoon, A question was asked of me today if there is multiple choice column in development. We use the drop-down list column, but one that allows you to choose multiple entries would be fantastic. Blessings, Loann