Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
How to build bar graph of submissions by userIn Formulas and FunctionsWe are using Smartsheet to build a Change Management process for our IT department. The way it currently works is we have a form that users fill out containing all the details of their change request, which are recording to a spreadsheet.…
-
Summing Data From Another SheetIn Formulas and FunctionsI have a resource tracker that is set up to sum hours by resource using the =SUM(CHILDREN()) Function. I also need to be able to sum hours by Project Code (Column 4), and Classification (Column 8) by Month. Can someone advise on the best…
-
Formulas for flagsIn Formulas and FunctionsI need some help with formulas - cell names are in brackets. If [HRSS Sends Request for Personal Info] has a date, AND [Credentialing Initiated HRSS] is blank after 7 days, flag If [Credentialing Initiated HRSS] has a date, AND [App Comple…
-
Skip blank cells with YEAR functionIn Formulas and FunctionsI’m endeavoring a roll up sheet that will provide sum totals from a single row on a separate Planning Request sheet. If the source sheet has all cells filled out, the formula seems to work fine: =SUMIFS({Planning Request Range 2}, {Plannin…
-
COUNTIFSIn Formulas and FunctionsTrying to count how many cells that correspond to a specific region that are "Proposal", or "Committed", or "Executing". Trying to learn from my use of SUMIFS for this, but the following gives me #INCORRECT …
-
IF Statement to return a Flag SymbolIn Formulas and FunctionsHello! I've got an IF Statement created to leave the at risk flag blank if the "done" box is checked, and make the flag red if the due date is within 5 days of today. I can tell it's working because it's populating at "1&quo…
-
Update Request - Read-Only fields?In Formulas and FunctionsIs there any way to send an update request, but only have certain fields editable? The issue is that I need to send some contextual info on the update request, but some fields should *not* be changed. If I only send the update request for…
-
Flag FormulaIn Formulas and FunctionsMy formula for the below isn't flagging correctly. Can someone take a look at it? Intended action: If [HRSS Sends Request for Personal Info] has a date, AND [Credentialing Initiated HRSS] is blank after 7 days, flag Formula: =IF(AND(ISDAT…
-
Add a Metric widget on a dashboard that shows last modified date & timeIn Formulas and FunctionsI am trying to add a metric widget to a dashboard that shows both the date and time from the last modified column in a sheet. It seems I can only bring in date, not time. Is there a way to show both elements? Thanks.
-
Date FormulaIn Formulas and FunctionsHi everyone, Is there a formula in which I can calculate the number of days in any given month? Regards Rainier