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

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Tally Number of Years with a Starting Date
I'm new to SmartSheets, so be gentle . I want to insert a formula that will automatically tally a number of years from a given start date every year. Example: I want to know the number of years a person has been in a given rank. I have the rank date set at 8/16/17. Every year on 8/16, I want to automate the column…
Pin sheets to top of workspace
Hello, I have a Workspace that will soon have several dozen sheets or more. I have a Template for this Workspace and a Smartsheet on how to use the Workspace for my organization. It is going to get very easy for these two important sheets to get lost. Is there a way I can "Pin" them to the top of the list?
Help! COUNTIFS Formula Logic with 2 Date Fields
I am referencing V2.0 of a shared spreadsheet that now has 2 "Created Date" fields: 1) the system generated CREATED column that will be valid for all new entries going forwards, and 2) a LEGACY CREATED DATE column that reflects when older entries were originally created (before they were imported into the new sheet. I have…
Custom column changes places when copy between sheets
Just wanted to point out that when I did a <Copy to Another Sheet> I discovered that a custom column placed in the first sheet did get copied but it was placed at the end of all pre-defined columns in the second sheet. A bit confusing since that place was out of view in the Gannt-view...
Copying Alerts From Column on Sheet 1 to Column on Sheet 2
I've set up a set of three alerts triggered by a date in a column and it's quite lengthy (but works). I now want to eliminate rekeying it to 15 other sheets within the same workbook by copying the alerts and placing them in the remaining sheets. Is there a way to paste them into another sheet? Please let me know if anyone…
20,001 rows limit exporting to excel
Just encountered the hard limit of 20,001 rows when exporting a report to Excel, Took me awhile to figure out what happened. Just wish there was a simple prompt to alert me to the issue. 20,001 is a bit low in my opinion.
Formula not filling down after pasting data from Excel
Hey guys, I'm new to this and this is likely to have already been solved elsewhere, but I can't seem to find what I'm looking for. my process requires that I copy data from a CSV file and paste into my sheet where the top rows have applied formulas. The formula, however, is not filling down automatically. Any thoughts,…
Changing the Color of a Font Based on Values
I am trying to change the color of the font based on whether the percentage is between a certain range. However, it doesn't seem to be working correctly and is just changing the entire column red. Have I done something wrong in setting up the conditional formatting? The column is completely formulas, so they aren't values…
Managing (deleting) cross sheet references
If sheet A contains 5 unique cross sheet references (each filled down through 1000 rows) in order to look up values on the master sheet and I delete all of the rows in sheet A, does that also delete (free up) those 5000 previously used cross sheet references? Thanks!
If function for issue flagged
Dear, I just wrote the below formula that update the status with RYBG indicators. however, I am having issue with the last if function of the formula "Flag Issue" part. I want the status to change to red when an issue is flagged or checked and it is not working. Can any one please help. =IF(Status2 = "In Progress",…

Popular Tags

Trending in Smartsheet Basics

फोनपे गलत लेनदेन की शिकायत कैसे करें
फोनपे से पैसे कट जाने पर, ये कदम उठाए जा सकते ग्राहक सहायता से संपर्क(O76~071~42897) है पेटीएम ऐप में जाकर, “ट्रांज़ैक्शन” या “इतिहास” सेक्शन में जाएं. असफल लेन-देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें…
मैं कुकू एफएम से शिकायत कैसे करूं?
कुकूएफएम मई को स्वचालित भुगतान रोकने के लिए, उनकी ग्राहक सेवा हेल्पलाइन नंबर O82998×84347 // संपर्क करें और ऑटो-पे को अक्षम करने का अनुरोध करें।✓
IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags