-
How to link a column to another sheet so I can run a formula on duplicate values?
Is there a way to link a whole column to another sheet? I need a whole column linked, not just cells. Copy and pasting 500 cells at a time is not going to work, as it will not update if rows are added or deleted. I considered a report, however that would only accomplish part of the job, as I want to filter the results. I…
-
Daily metric widget problem in dashboard
Hi, I have a problem with a metric widget I would like it to show me the row that is for current day. Is there a way of doing it or do I have to make a report.
-
Toggle Hyperlinks
I have a need for a cell to hyperlink to different URL's based on whether or not the logged in SmartSheet user's email address (i.e., SmartSheet ID) is internal (i.e., works for our company - e.g., tim@ourcompany.com) or external (i.e., one of our customers - e.g., bill@clientcompany.com). Is there a way to do that via a…
-
Autofill field using the IF function
Hi I have two columns. One is called "Hierarchy" and the other is called "Description" I'd like to have "Description" automatically filled with this text/forumula "=PARENT()" if the value in the Hierarchy column is "2" Can this be done using the IF function or through another method? Thanks
-
Countif rows meets multiple criteria
I'm new to Smartsheet, and I'm trying to count the number of incomplete tasks by SME area within a task list. How do I write COUNTIF formula that will count a row IF the Status column does not equal Complete AND the Area column equals Vocab? The ultimate goal is to depict on a Sight the number of incomplete (i.e., active)…
-
# BLOCKED
Hi, Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error. Originally, the formula was more complicated, so I tried troubleshooting to see which function is broken. Right now, the only thing in the cell is "=COUNT([Task Name]:[Task Name])" All that is doing is counting all…
-
If Index Match
Hi, I'm trying to figure out the due date for a submission if the dates remaining is >0 below is the formula I came up with, however it is not working. =IF(INDEX({Due Dates}, MATCH([Client Matter]2, {Client Matter #})), {Days Remaining}, @cell > 0) Also, is there a way to do an Index Match or vlook up that gives me the…
-
Formula to calculate project number based on group
Hi I want to calculate a project number based on what group it is in. In this example, there are 16 projects among 4 departments. I entered the 3rd column manually; i.e. the first digit is the department number and the second digit is the nth project for that department. What formula can I use to calculate the values in…
-
Smartsheet Forms - Apostrophe automatically added to formula
Hi All, I've just started creating a Smartsheet form for people to easily add data however one cell should just be a formula so I'm using the 'Default Value' under field options but when the form is submitted an apostrophe is automatically added to the front of the formula rendering it useless without editing it. I've…
-
Formula is not copying
Hi, I am having a problem with one formula that is not automatically copying to a new row (there are others that are being copied). The formula is: =JOIN(CHILDREN([Column Name]1, ", ") Why every other formula is being copied but not this? Thanks.