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

Dashboards
I have a dashboard layed out with widgets and want to use it as "template" for new projects that come in. How do I do this? I tried copying it along with an updated metric sheet but all my links for the dashboard are for the previous project's metric sheet. I supposed I need to relink to the new metric sheet however when I…
Assistance with UNPARSEABLE error
Looking for another set of eyes as I'm getting an UNPARESABLE error… I can't seem to find the issue … Details Using an INDEX MATCH from a checkbox column to populate a Text/Number column Formula =IF(INDEX({_Checkbox}, MATCH([Site ID]#, {SiteID}, 0))=true, “Yes”, “No”)
Updating Average of most recent cells?
Hello! Quick question I've been stumped on. I have a sheet that tracks hours worked on different projects each month in a year. I want there to be a cell that displays the average of the most recent 3 months. Of course, I'd want this to update when a new month is entered. That value would be used along with the "hours…