IF Type = Project join Type+ID+"-"+PMO Project Name If Type = Request join Type+ID+"-"+Request Name I've tried this a couple of ways - if I select Request - it comes up as Request1000-RequestName If I…
I cannot get the function below to calculate correctly. I keep getting 0 for the sum. =SUMIFS({Hours}, {Input Date}, MONTH({Input Date}) = 4, {Project ID}, [Column2]@row) {Input Date} is a column refe…
EDIT: on refresh, this error message actually disappeared and I can now view the Activity Log in it's entirety without adding a date range filter. This is also happening on another few old sheets - er…
I'm having a hard time combining a formula that when I check off the "Done" checkbox it turns the % Complete to %100 and also changes the health to green as well as combining the criteria of this form…
Hi Community, So, I am trying to save myself a lot of manual data entry. Ultimately, I am trying to take a spreadsheet that was created in Excel, to capture each persons "qualifications" in a specific…
I created a Smartsheet Form and have begun receiving responses. One user indicated his response would not submit (See attachment). I verified his responses were not recorded on the Smartsheet. He indi…
I have data coming into Smartsheet from a Microsoft Form, and I'm not sure how to get smartsheet to recognize the data as a date. I tried to create an additional Date column, and putting in a formula …
Is there a way to surface text from one sheet to another if a checkbox is checked on the source sheet? I have a sheet with a list of meeting participants and checkbox columns for each of the meetings …
I have a Helper Column that I've created in order to tally Late Tasks based on entries in other fields. I want the Late Task column to be populated with 1 if the following conditions are met: [Open Ta…
I am looking to join multiple columns using a "-" as deliminator and I dont have the columns side by side to select range and use Join function. I also want it to skip columns that are blank. Also - I…
