Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

F4 funtion in excel

Ordep

Ordep ✭✭

07/09/15 edited 12/09/19 in Archived 2015 Posts

Could someone tell me what the equivalent in smartsheet is for the F4 funtion in excel that fixes the cells within a formula?

Tags:

0 ·

Comments

Ordep ✭✭

07/10/15 edited 07/10/15

Found it!!!

Toggle Ctrl L

0 · Share on Facebook Share on Twitter
Travis Employee

07/10/15 edited 07/10/15

Glad you found it! Here is a list of keyboard shortcuts in Smartsheet: http://help.smartsheet.com/customer/portal/articles/522200-keyboard-shortcuts

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

How to create a formula to pull the first part of an order number into an adjacent column
Hello! I am struggling to create a formula to pull the first part of an order number (our internal agency numbers) into a separate column so I can see how much each agent sends in each month. Screenshot of the order number below:
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…
IF Statement to Display Symbols
Formula variable question for an IF Statement. Ok I have 5 columns (see screenshot below). This formula will be added to the one on the far right (Certification Complete). Now I would like to assign a value to each to trigger the symbol that will display. Basically the way it works is that all 5 columns are required, if…