-
Auto-Number Fields on Form Creation
Hi Is there a way of Auto-numbering Fields during a Form creation? Put simply can you automatically number questions 1, 2, 3 etc? Or can this only really be done manually by changing the column titles? i.e. 1 - Where do you live? (for example) Many thanks Nick
-
Multi-Sheet & Few Clicks
I have an assessment sheet where 2 different rating columns are linked to the rating key at the top of the column. Would it be possible have the Rating Key Sheets linked or formulated so that when a rating is selected on the key, it'll enter it into the cell on the Assessment sheet? Does anyone have any suggestions / best…
-
Cannot Remove Hyper Link on Phone Number?
Please Help, For the life of me I cannot remove a hyper link. I added a simple telephone number and it show as a link (blue with underline) I want to remove this as it not a link, just a number. I tried all methods that would normally remove this. i.e right click on cell (no remove) Ctrl C - Ctrl V (even special paste…
-
Start Date Autofilled by End Date and Duration
I'm building a construction schedule for cabinetry across multiple projects my company has going. Is there a way to dictate a start date, date the vendor needs to start working, by the known building/finishing time and the end date, date they need to be on site. I.E. I'd like to put in the end date: 1/22/18 and a duration…
-
Sum formula Error When References Results from IF Formula
I am getting an #Invalid Operation error when my Sum formula references a cell with results from an IF formula: =SUM([Column 8]1 * [Column 9]1) results as #Invalid Operation error Column 9 formula =IF([Column 2] = "A", "0.5%", IF([Column 2] = "B", "1.5%")) I've tried to fix by using a nested VALUE= but that does not work…
-
[Need Help] Non-License user can hide column but can't unhide?
Hi, I understand that only License user can hide or un-hide column in sheet they are admin. * Hide/unhide columns (also requires Sheet Owner or Admin access to the sheet) But we have some user (non-licensed but part of our Business) that are able to shrink a column in a sheet they are admin, but they are unable to unhide.…
-
Question: Automated To-Do List by User
Is it possible to build a report that automatically pulls a to-do list for the logged in user from all open project sheets, or do I have to build a separate report for each user and send an updated link each day?
-
Activity Log Export
Is there a way to export the Activity Log once filtered? We would be able to use this for our metrics. It would be a huge time saver and really make SmartSheet that much better for us! I am sure this could be used in this manner for other companies as well. Thank you!
-
Report Errors in Cell History
I have a report that goes out daily showing which items are past due. The report is generated based a column that creates a flag when the line item is past due. On Monday the report went out but says that some one made the change to the cell according to the cell history. The report also looks the receivers that it came…
-
Not showing me who is in a Smartsheet
I use Smartsheet every day at work and am one of the licensed users. Today I am noticing that it isn't showing me who is in a given Smartsheet. I know someone is in it because I'll see the notification to refresh because they've made changes (they will be making updates all morning). Has anyone else noticed this? Thanks!