Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.

Product questions?
Ask it here! The community's got your back.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Formula to get the last value in a data range
Is there a work around that will provide you with the last value in a data range instead of the first as vlookup would do? Also, we would need to ignore any cells that were blank.
SUMIFS Formula for Rows Assigned to Multiple Contacts
Using the Sheet Summary function this formula worked: =SUMIFS({Budget Projected}, {Budget Account}, Variable@row, {Budget Assigned}, Employee#) when the lined was assigned to only one contact, but now that I have lines with multiple contacts assigned to them it will not recognize even the one employee's name anymore. I…
Limiting a column to only allow for 2 checkboxes then lock it down
I have a smartsheet where I'm wanting to give employees an option to select a date and time for training. But once a date and time have been picked by two people, I want that column to lock down, show unavailable. I'm researched conditional formatting and formulas but I am a novice at both. Help?
Index/Match/Max/Collect
Hi all, I am having trouble putting together a formula and I am hoping someone here can guide me in the right direction. We have a sheet that we enter payments we receive from our customers. That sheet has the customer name, check date, deposit date and amount etc. I am looking to create a sheet that can give me the latest…
Using COUNTIF in Sheet Summary
I am trying to use a COUNTIF formula in the Sheet Summary. I have a column called, "Current Project Status." I want to count the total number of times the word "Operational" appears in that column. I have entered this into the field with no luck; "=COUNTIF(Current Project Status:Current Project Status,Operational)" I have…
Error Message
Hi Community, i have a problem with this error message. Could someone help me? Do Smartsheet have a maximum of links per sheet? If yes, what should I do? Or did i do something else wrong? Thanks for your help!
Calculate number of hours worked in a month
I have one sheet where I am going to track the number of hours worked on a project. The individual will put the hours in and date worked. In a roll up sheet I am trying to calculate the number of hours worked per month Sheet 1 Sheet 2 In column3 and am trying to add up the number of hours worked(used) for Dec 2020 and each…
Can I get help with formula to count number of sold notifications current month?
This formula is giving me an Invalid Data Type message. I am trying to do this in Sheet Summary. =COUNTIF([Date Sold Notification]:[Date Sold Notification], MONTH(@cell) = MONTH(TODAY()))
excel translation
=+AVERAGE(SUMPRODUCT(F$13:F$19,$D$13:$D$19)/SUM($D$13:$D$19),F20,F21)
Counting Dates within a Date column
Hi all, I'm trying to set up a formula that counts specific dates within a date column, using the following approach: =COUNTIF({Reference 1}, "31-12-2020") It keeps returning 0 when there are least 4 dates within the target column that match the specified criteria. Can anyone advise how I can fix this? Many thanks in…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Is there a way to stop automations when the person being notified is the person that trig
Is there a way to stop automations when the person being notified is the person that triggered said automation?
Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…
Calculating the total duration from a date & military time start and end
I have been looking at a lot of information on this site and this is the closest one I have found, however it does not calculate the minutes correctly. For example instead of 8hrs and 45 min it gives me 9hrs and -15min. Formula: =(([On-Site Date]@row - [Notification Date]@row) * 24) + VALUE(LEFT([Time of Crew arrival]@row,…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags