-
Linked Cells with Numeric Value not working in Chart Widget
Hi, I have a roll up of numbers for the total of checkboxes checked off in our main data sheet. I've linked that totaled value into a separate sheet via the link cell capability. That is somehow not getting charted, and is showing up as "Invalid data"? What am I doing wrong?
-
API for linking MS Excel to SMARTSHEET
Greetings I am handling a number of projects and making Gantt charts to track their progress. The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manually import the dates and numbers to update the Gantt chart. I want to know, if there is way I can circumvent this problem. I…
-
VLOOKUP is data type of TEXT instead of DATE - sorting is off
I am currently creating an report which looks up dates based on specific milestone tasks over a number of project sheets. When the vlookup calculation is entered and I hit the Return key, is it giving me an alert that the value is not in date format. Being the admin, I am able to override this. But when sorting, it sorts…
-
Using One Checkbox to Check Another
We have a task sheet that uses 3 checkbox columns (Sent, Received or Done, N/A). We have a formula that counts the number of tasks and how many are completed based on the Received or Done column. We are trying to make it so if the N/A box is checked, it automatically checks of the coinciding Received or Done box. Please…
-
Automating RYG balls
I would like to automate the RYG balls in my sheet to turn “Green” if the Due Date is in the future, “Yellow” if the Due Date is today, and “Red” if the Due Date is in the past. Is this something Smartsheet can do?
-
Filter - Add new checkbox, Include Children
In the filter section of Smartsheet I would like an option to include children (another checkbox). Currently you can check to Include Parent, but in my case the parent holds the status for all of the children.
-
Any way to stop lines from being automatically added?
I'm setting up budget docs for several people, and Smartsheet automatically adds lines to every sheet. Unless the budget owner is paying attention, this will screw up one of the formulas. Is there any way to turn this feature off?
-
Add Forms Button to Sheet UI
It would be beneficial to have a Forms button on the right side sheet UI border. Similar to the Attachments, Comments and Update Requests buttons. Thanks,
-
The "New Smartsheet Navigation Experience" is Great! TY!
The New Smartsheet Navigation Experience is GREAT! The #1 feature I'm excited about is Browser Tabs and Direct Links. Being able to copy the URL straight from the browser. I spent a LOT of time as a champion and mentor explaining how to get the URL to share a specific sheet. I really believe this will enhance the new user…
-
Status Change if Column Checked
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…