- Copy and move selective columns
many times we prefere to copy/move selective columns ( within the row) either direct or automated , biut unforunately the platform force me to share the whole row with all columns including those columns with info that i do not wish to share . Please consider the feeature to direct or autmated copy/move selective columns…
- Copy specific cells to another sheet
Hi , Is it possible with automation function to copy specific cells from choice to another sheet with out copying the complete row with all columns For example To cop cells in column A, B and F to another sheet without copying middle cloumns D, E etc Thank you
- Multiple columns condtional furmola/formate
嗨,我车队司机马nually on daily basis type the KM/Millage reading in Column (Km/Today) I need formulla for column Alert as follows: - - - - - - - - - - - - - - - - - - -- - - - If number in col (Oil Next) is less than col ( Km/Tiday) the alert Col is (Green) AND If number in col (Oil Next) is Higher…
- Input/auto fill data from different rows
Hello, Please find the example photo I would like if there is a formula that can auto fill and input data in blank columns/same row once i type the phone number (in column phone) by calling or looking up for the data from other rows in same sheet (or from other data pase sheet) taht engaged with same phone number. For…
- Copy & Duplicate pack of sheets/Folders
Hi , I have number of sheets to collect data periodically on monthly basis with own automation/task and work flow and many of sheets are linked and reading data from source sheets . The above folders/sheets i create them every month using template function creating the sheets , and linking them again / rename it every…
- Formula to calculate working hours
Hello Team , Please see attached photo above Im looking for away to count my employees daily working hours (in working hrs col) The Col names ( Shift Start and Shift End) are select down menu for 24/hrs (hrs and minutes separated with colons) I Need a formula for column (Working/hrs) that count the number of employee's…
- Additional data/fields for contact
Hello Team , The Contact feature as of now include only contact name and email I would like to suggest to add more fields for a contact . Example : Mobile and Phone , Address and photo specially for non smart sheet members This is will help us to reduce adding many columns that not needed just to add above data. might have…
- Formula for counting bonus
Hi , Please find attached screenshot above .. i would like to create formula to input it in Cloumn [Bonus] to help us to calculate daily bonus for our employee sales as follow .. (1) if amount in Col [Daily Income] is higher than amount in Col [Target] to calculate the following Calculate 60% of the difference amount…
- comment on cell
the comment option is available for row , how to create comment on specific cell ?
- Salary Formula ( Calculation of Basic and commission)
Hi , I need formula for (Net Salary) col as follow : To Count the sum in Col (Basic Salary) Plus sum of 15% for amounts equal/less than 600 and sum of 25% for amounts more than 600) of the number in Col (Total Income) We Pay our Employee (ex. sales man) salary with compensation of basic salary PLUS markup commission as…
