-
SUMIFS calculation
I have entered the current formula but get invalid operation, not sure why. Seems to be something with the >50000 as the formula works when I remove this. =SUMIFS([1 July 18 - current]2:[1 July 18 - current]396, >50000, [Contract Status]2:[Contract Status]396, "red") Help would be appreciated.
-
How to print a list of column headings?
Is it possible to print or create a list of just the column headings used in a sheet? And, ideally, include any list (e.g., values listed for dropdown boxes, symbols) associated with each heading? We have a sheet with over 50 columns and would like to find a way to keep track of the headings and their lists. I've checked…
-
Widget in Multiple Dashboards
I'd like to have a particular chart show up in multiple dashboards. Is there a way to copy or link the widget between dashboards? Having to re-create each time will be pretty time consuming. Thanks.
-
Default Card View Always Show Field Labels Caret Toggle
How can I force Card View to always show the field labels associated with data on all cards? I don't want to require users to click on the little caret symbol that toggles labels to display on each card... I want all field labels to always show on all cards all the time.
-
Sending approved requests to Outlook Calendar
I am looking at creating a form that will allow my team to submit requests to go into the field for work. This is part of their job and I just need to make sure it is more formally captured with information about where they are going and what they are doing. Can I create a form and then once I approve the request it adds…
-
Modifying resource views
Good day and thanks in advance! Doing as I understand it's supposed to, when i open a resource view and select (and expand) a resource, all sheets with that resource are there and roll up to the total resource allocation for that resource. My challenge is that I have multiple earlier versions of plans I've developed, with…
-
Report for files not modified in last 45 days?
Is it possible to create a report to list all files (sheets) in a folder not modified in the last 45 days? To be clear: I know how to run a report that shows the ROWS modified within the sheets. I want to know when the SHEETS themselves were last modified. Background: Currently I have a folder with hundred of sheets. They…
-
Day and Time
Hi, Is there a way to track time of day by task? Thanks Cheri
-
Rounding to a Floor
Hello, I'm trying to round a calculation to the lowest quarter (ending in 25,50,75 or 100). The Excel formula is =FLOOR(132,25) equals 125 =FLOOR(168,25) equals 150 Smartsheet doesn't recognize the FLOOR function; any help is appreciated
-
Not able to moving cards into touch screen monitor.
Hello, I'm using the smartsheet on the touch screen monitor and I have set the appearance as a card view on Gantt charts. With using the mouse I'm able to move cards, But while using the touch on the screen, I'm not able to move them. Please see the attached snap and let me know if there is any solution to resolve it.…
