Formulas and Functions
Archives for January 2021
Discussion List
-
Formula for StatusIn Formulas and FunctionsI would like to auto create a status based on an end date, completed date, cancelled checkbox or on hold checkbox. If end date is in the future an neither checkbox is selected then "Open". If the end date is in the past then &q…
-
Automate formulaIn Formulas and FunctionsIs there a formula that can do the picture below.... the Blue unlined column is provided in the form request, The Black underline column needs to recognise the contract id, then find the last V number allocated and allocated the next numb…
-
Count Hierarchies without including dupesIn Formulas and FunctionsIs it possible to count the number of the hierarchies? Right now, I'm using the count function and manually clicking on level 1 for those counts and level 2 for those counts. My document is rather large and I don't want to click through e…
-
Unparseable ErrorIn Formulas and FunctionsDear Smartsheet Community, Very new to Smartsheet and having trouble with 2 formulas that work in Excel. =IF([Date Approved] = 0, [Date Calculation],"Completed") =NOW() - [Date of Submission] Could you kindly let me know if the f…Answered - Pending Review 283 views 4 comments 0 points Most recent by Kelly Moore Formulas and Functions
-
ISBLANK or 0 (ZERO) : Formula for a columnIn Formulas and FunctionsGood afternoon, I have the following formula that is populating my "HRS Left" column =IF(OR(ISBLANK([email protected]), ISBLANK([email protected])), [email protected], SUM([email protected] - [email protected])). But I need to be able to write the formula so that the "HRS…
-
Hi, can anyone help me to get my Green/Yellow/Red/Blue Status to work correctly?In Formulas and FunctionsI have to write a green/yellow/red/blue status indicator with a risk override field as well. The concept is that if the Risk Override field is populated then that should be the status. The risk override field will be a drop down between …Answered - Pending Review 11 views 5 comments 0 points Most recent by Kelly Moore Formulas and Functions
-
Can I create a hyperlink by combining text strings and fielded data? Pretty basic parameter workIn Formulas and FunctionsI have fields: email: subject: body: I want to use this hyperlink to open an email with those parameters: <a href="mailto:[email protected]?subject=This is a subject. You can't use certain characters in here. But we should be able …Answered - Pending Review 23 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Using SUMIF to have a blank cell if data comes back zeroIn Formulas and FunctionsI am pulling data from another sheet. I am using a SUMIF to sum things off a certain date and if it meets a certain name. When it has no data to bring back, it shows a zero and I would like for the cell to be blank so that my charts do not…
-
Formula to show text next to sum amountIn Formulas and FunctionsGood day, Our Currency ( BHD for Bahrain Kingdom ) is not one of listed currencies and I wish to show it to amount numbers , how to have Currency BHD seen next tp total sum in below formula ? =SUM([Service Charge]4:[Service Charge]13) Als…Answered - Pending Review 21 views 5 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Copy Row Automation causing duplicatesIn Formulas and FunctionsI am using an automation that copies rows which contain the word "submittal" into a sheet where we are tracking submittal dates for all our projects. I cannot use a report because we need to be able to publish to a calendar. Ther…Answered - Pending Review 169 views 3 comments 0 points Most recent by Melissa Boehl Formulas and Functions