-
How do I get the exact number of Years based on the date column (no more rounding up)?
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…
-
Published calendar view not showing all tasks
When I publish the calendar view, not all my tasks are showing up. I have all filters off. In my regular view on the sheet, the tasks are there.
-
Cell Behaviour for Cross Sheet Reference Formula with Daily Source Sheet Data Refresh via Data Shuttle
Hello, I have a metrics reporting sheet that relies on cross sheet reference formula to count rows from a formula column in a source sheet (let's call it Sheet A) that refreshes with data via data shuttle (set to 'Replace all target sheet rows with the data from the input file') once per day at 8 AM UTC (I am in PST). One…
-
Character limit for pull-down menu items
Is there a limit to the number of characters for a pull-down menu item? If so, what is that character limit and are there any other limitations such as special character use?
-
Help!
I have a vision i know what I want but I cant seem to figure out how to do it. Anybody up for a zoom or teams call to help me?
-
Salesforce integration
Hi all, Newly "back" to my organization, Smartsheets is a new tool they use. I have taken a lot of the video training, but I haven't found one to understand how Smartsheet and Salesforce work together. Can anyone guide me or post where I can find the training?
-
Web Version Loads The Same Sheet
Hello, With the new update I'm experiencing an issue I didn't have before. I use Smartsheet web version because I typically work with 20-30 tabs open and it makes it easier to use than the app. Since this new update, every day when I open my laptop I am prompted to log in (as usual), but when the sheets load they all open…
-
Can I count cells between number thresholds if the cell also has text in it?
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…
-
How to Preserve INDEX Formula Data When Archiving Row?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
-
Merged: We need a way on a Project Schedule to delineate certain items can be completed on the weekend without turning it on for the whole sheet
This discussion has been merged.