-
Struggling with multiple IF Statements
I am new to Smartsheet and struggling a bit to get Multiple IF Statements to work. I'm trying to get a number/score to render to an adjacent cell when an item is selected in the cell beside it. Having absolutely no luck here. (Attempted) Syntax below. Thanks in advance for your expertise. IF([Strategic Alignment]1 =…
-
Subject line of email notifications
Hi all, My team uses the chat feature in a shared spreadsheet. We receive email notifications from Smartsheet when someone has replied to a chat we're following, or if we get tagged in a chat. Is there any way to customize the subject line of the email notification? Thanks, Christina
-
Copy Row and Cell History
Hi all - when I Copy Row into another sheet a lose the Cell History. Does anyone know if that is working as designed? Per the below link I thought the cell history would be preserved? Probably too much to hope for :-). Thanks very much Julia…
-
Count between ranges
Reaching out to see if my formula, which seems to be working, is the correct way to COUNT between two ranges. In my example - I want to count a category name AND only if the % Complete range is between 25% - 49% FORMULA =COUNTIFS({Function}, "Asset Protection", {Percent}, >0.25, {Percent}, <=0.49) As mentioned this seems…
-
Using Contents from one Date cell to update another Date cell
Im trying to use a 'helper column' to run a formula that checks the contents of a date column/cell, and copies those contents to another date column/cell. The code I'm using is quite simple, so I feel that I must be making a silly error, or it is not possible. To re-iterate, I have a cell specific date column , and I want…
-
CONTAINS a blank in region
Id like to create a formula that looks across 5 or so rows, that can report if any are blank. Ive tried to use CONTAINS but it doesnt appear to work when i use "" to signify finding a blank cell. Online Help seems to suggest that i need to use IF with CONTAINS to gain my result. Do i? I get something to work with bu doesnt…
-
date formula and outstanding loans
i use this formula in excel to work out years and months left but does not work in sheets =DATEDIF(0,I2,"y")&" years "&DATEDIF(0,I2,"ym")&" months "&DATEDIF(0,I2,"md")&" days" what i am doing i have few out standing loans which i make reduced payments on i and need to see how many years i have till they are paid off at…
-
What is the best way to set up a multiple entry item list/field within a form?
I'm not sure I worded that my question correctly, but I am trying to create a form at the moment that, in addition to several other questions/fields, asks the user to submit any income/deduction items not already set up and for each entry to give the EE Name, EE #, EE Type, Income/Deduction Name & Amount. Is there a way to…
-
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…
-
Formula modification help.
I need to modify a formula to pull values of two different cells "SAP PROJECT NUMBER" and "JOB NUMBER" from another "Time Tracking" sheet. I make it work with pulling just one lookup but not two. Below is my formula for one - where to I add the [JOB Number] so it pulls both in this formula? =SUMIFS({Time Tracking Range 4},…