Formulas
Discussion List
- Hello, to this formula how would i add another sheet to get the match from? this formula says: match employee name, and if the column (sheet 1) has this document title return green, if it doesn't retu…
- I've noticed when trying to run formulas on my AutoNumber column, that it doesn't always work. Here's a table of some of the results. For each row I changed the autonumber "Numerical Places" from 0 to…
- In Smartsheet I have a contact column (Project Support) that can have up to six contacts (first name + last name), for example Jane Doe. I then have six other Test/Number columns that pull the first c…
- Auf einem Projektplan wird mir der Erfüllungsgrad des Vorhabens durch die Abhängigkeitseinstellungen (Start/Ende/Erfüllungsgrad) wiedergegeben. Auf einem Projektedashboard möchte ich gerne tagesaktuel…
- Hi there, I am hoping to crowdsource some creative answers to a question that has been asked of me by my leadership team. I currently have a Project Management Office/Organization set up in Smartsheet…
- Hello community :) Is it not possible for % Complete to default/autofill to 0% when inserting a new row? When I insert a new row (between 2 other rows) and enter text in the Primary Column, everything…
- Hi all, Through some trial and error I created a Time Off Request system for my team (80 people) I started with grid rows: Employee Email (text), Supervisor Email (text), Division (drop down), Time Ty…
- I am trying to create a sum of the same cell in four different Metrics Sheets. I have created the following formula and I get the Unparseable error. Would appreciate help, please.
- Greetings, I set up a very simple form pictured below where someone could select their name from a drop-down and hit submit. On the back end, I have a column called date which enters the date and time…
- Hello Everyone, My master data sheet has a column called "Date Opened" where the date is formatted as Day-Month-Year. I am creating a dashboard and want to create rolling averages. I would like it to …