-
Help with Budget Health formula
I stink at formulas and am trying to calculate budget health. If my Budget is greater than my Actual, it's green. If my Budget is less than my Actual, it's red. I'm using =IF([Budget]@Row > [Actual]@row, "Green", if [Budget]@Row < [Actual]@Row, "Red")) How do I write this correctly?
-
How do I identify the cell in a column that has a value NOT in the restricted list?
How do I find the offending cell? I imported an excel spreadsheet to a smartsheet. I converted a list of names column to a Contact column I manually created these people in My Contacts and converted the imported text to Contacts. I check the box to "restrict to list values only" I get this message: How do I find the…
-
Pivots and Scatter
Hi all, I"m hoping to get more ideas on how to best display my data. I track headcount and hiring for my team, I have created a column that will provide me with the age of the role (how long the role has been "open" for, in days). Because I run multiple portfolios, I set up a pivot that breaks down each Portfolio and the…
-
Drop down multiselect column - getting count data
I have set up a form with a multi select list and I need to be able to tally the selections against each of the items. I have looked on here a lot and tried various versions of COUNTIF and COUNTIFS and COUNTM and have exported to Excel and tried to do it that way and cannot figure out what to do. Can someone point me to…
-
Need Help validating & correcting formula
Goal: I am trying to count the values in the 'Hours Worked' column for each month. The 'Date Worked' column is the date that determines the range (i.e. September 1 - September 30 2021). Having trouble finding a formula for this. =SUMIF([Date Worked]:[Date Worked], >=DATE(2021, 9, 1), Date Worked, <=DATE(2021, 9, 30))…
-
Share multiple workspaces at one time
I have a new colleague that I want to have access to all of my workspaces. Is there a way to share all of my workspaces at one time without having to individually share each workspace? I have over 200 workspaces.
-
sending tasks from one smarsheet to another
Hi all, I use a smartheet to receive inputs, considered as a task, with a form. when the team fill the form, it became a line in my worksheet. I have to check this tasks and if I consider I have all inforation is goodand the task shoudl be exectued, I woul like to click in a cell and this line sould be updated, or mirrored…
-
microsoft project import problems
When i import my SMartsheet XML export into my corporate MS Project environment, I only get a subset of fields and some data is changed. Has anyone else experienced and corrected this problem? Thanks Robert Young youngr@unhcr.org
-
Reporting Indicators
Hey All - I'm creating a graph in SmartSheets, and wondering if there's a way to create an indicator (line, tick-mark, etc.) that would show as part of the graph where I could mark certain changes. In this graph, I'm showing Employee Capacity vs Forecasted Time, and I want to indicate when an Employee either left/joined…
-
DocuSign Tracking from Reports
Hello all, Can you tell me why I have tracking status when I create a DocuSign mapping via a sheet, but not when I do it via a report? See the attachments that show the difference. DocuSign Mapping from Sheet: DocuSign Mapping via report: Both work to generate documents via Docusign, but I can't get it to track via a…
