find if thre is a formula in a cell?1 Recommended Answer
how do I, say, insert another formula (g9) to look on c9 if the formula was deleted?
var r = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getActiveCell();
return ( r.offset(rowoffset,columnoffset,1,1).getFormula().length != 0 )
thank you so much
A1 will be the cell I use the EXPAND function (hidden to the user)
B1 and C1 user enters data
D1 will have the calculation: B1*C1
can you help me do this? I can't find much reference on help with this function
Some community members might have badges that indicate their identity or level of participation in a community.
Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:
- Post an answer.
- Having your answer selected as the best answer.
- Having your post rated as helpful.
- Vote up a post.
- Correctly mark a topic or post as abuse.
Having a post marked and removed as abuse will slow a user's advance in levels.
View profile in forum?
To view this member's profile, you need to leave the current Help page.
Report abuse in forum?
This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.
Reply in forum?
This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.