-
The correct VLOOPUP formula?
Hello I am needing a formula that will pull an employee level and assign it to the alias listed. I have used differed variations of VLOOKUP and nothing seems to work. Breakdown: Sheet #1 will contain a list of an employee alias's, sometimes the alias will be listed multiple times. In the column "Level (Formula)" on sheet…
-
OFFSET Function
Hi, I need to calculate the sum across a number of columns that will change every month (mon columns are set from January to December for each year). This would easily be done in Excel via an OFFSET function and I can't find what the equivalent would be in Smartsheet. What I am trying to get at is this:…
-
HYPERLINK API
We have been using HYPERLINK("http://website.ws/links", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyperlink manually for each row is a terrible ordeal. It would be great if you add HYPERLINK("URL", "Text")…
-
How to set recurring reminders
I have been searching through the posts and found this formula: =IF(Complete4 = 0, TODAY(), “”) using my own column names. Each time I've tried to accept the formula, I get this error message: unparseable. Am I missing some of the formula (my Excel is rusty)? I want to have an email reminder sent daily until the task has…
-
Times in Outlook Calendar Syncing
I haven't been able to find a way include times with Outlook Calendar sharing after the last Outlook update. Any help on how I cna do this so that each event isn't listed as an "All Day" item would be great. Thanks
-
Smartsheet at- risk formula
Hi all, I'm having a little trouble with creating the right formula for my "at risk" / "attn" column. I only want the column to flag is the status is not complete and the target end date is past due. My current formula is =IF(AND(Status301 <> "Complete", [Target End Date]301 <= TODAY()), 1, 0) Currently, the column flags…
-
How to pull rows from a different sheet only if they're marked as "in progress" ?
Hi there, I'm looking for a way to pull rows from another sheet if they are marked as "in progress" (or any other status that's not "complete"). Ideally, I'd want to pull everything from that row and not just a single cell. Is there a way to do this? Thanks in advance!
-
Drop Downs
I'm using multiple dropdown columns on my smartsheet, most work, but a couple don't. When I try to click on the dropdown, nothing happens. Not sure why?
-
Help on IF Formula - Multiple Statements
Hi! I need some help on a IF Formula statement. On my sheet, I have a column that is using this equation - =IF([Total ALL Athletes and Unified Partners]@row = 0, "0", IF([Total ALL Athletes and Unified Partners]@row <= 5, "1", IF([Total ALL Athletes and Unified Partners]@row <= 74, "2", IF([Total ALL Athletes and Unified…
-
Is there a way to have a flag automatically turn red if a Priority column is "A"?