-
#INCORRECT ARGUMENT SET
Hi Team, I am trying to fix this formula but it keeps giving me an error #INCORRECT ARGUMENT SET Could you please help me fix this one it's kind of urgent to close. =IF([Calculation of Receivd to Warehouse]@row >= 31, "Delayed", IF([Calculation of Receivd to Warehouse]@row <= 30, "Expected next 30 Days", "Green",…
-
Can I add HAS formula to this existing formula?
I have a formula that pulls hours from one sheet if the department has been selected in a dropdown but the problem is that it has to be a single dropdown and we have multiple departments that could be working on the same project. I would like to find a formula that can pull the hours from the week but from a multi select…
-
Email Invite not transmitting to a license user
Why would an email invite show 'pending' for days? Invitee not receiving the invite. Confirmed email is correct with user.
-
Formula not calculating for each row automatically. Have to fill down.
Have a sheet that is populated by a form. The sheet has a column that has the formula: =IF([Tier Score]@row <= 17, "Tier 3", IF([Tier Score]@row <= 25, "Tier 2", IF([Tier Score]@row >= 26, "Tier 1"))) But when someone submits a new row, the formula does not fill down to calculate. I have to manually fill down.
-
Our first Overachiever Guest is here! [RECAP] Homecare Homebase x Sara Cook: Putting People
The latest episode of the Brand Collective Podcast is a treat for all of us. Featuring one of our very own Smartsheet Overachievers — @Sara_Cook! She’s the Marketing Director of Brand Management and Content at Homecare Homebase (HCHB), and also participates in several programs with Smartsheet other than the Overachievers,…
-
How can I convert this column into a date with the format MM/DD/YYYY?
I used the formula - =(([Hire Date]@row - [Term Date]@row) / 365) / 12
-
Column Headers & Color
This discussion was created from comments split from: Welcome to the online Smartsheet Community!.
-
Smartsheet contacts - Deleting Contacts
Is there a master list somewhere where these are stored? I deleted contacts from my personal contacts list but some contacts are still appearing as selectable on my smartsheets. What am I missing?
-
I need the Form to populate information to different sheets in Smartsheet
Hello Smartsheet community, Could you please advice, I need the Form to populate information to different sheets in Smartsheet depending on the dropdown menu choice. For example, there is a new project enquiry form, depending on the department choice information should be populated to the appropriate department's sheet. I…
-
Sheet Summary % Complete
I am feeling silly that I can't get this to work. I want to get the % complete of my project based on those with the status of "Complete" divided by all columns that have text in it. =COUNTIF(Status:Status, "Complete") / COUNTIF(Status:Status, ISTEXT(@cell))